USP_DATALIST_SPONSORSHIPGREATESTNEEDGETSMARTQUERYVIEW

CREATE procedure dbo.USP_DATALIST_SPONSORSHIPGREATESTNEEDGETSMARTQUERYVIEW
(
@TYPE tinyint
)
as
    set nocount on;

  if @TYPE=0
      select OBJECTNAME
      from dbo.QUERYVIEWRELATIONSHIP QR
    inner join QUERYVIEWCATALOG QC on QC.ID = QR.RELATEDQUERYVIEWID
    where QC.SUBGROUP ='Smart Fields' and ROOTQUERYVIEWID in ('B9CCCB7F-F957-4CA9-9C2C-DD2DEE3F079F','10DE43E9-ED66-4158-A08F-E4CEF6A82273')
     --Test for Numeric value.  removing restriction 3.7.12

     --and (SELECT  DATA_TYPE from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = QC.OBJECTNAME AND COLUMN_NAME='VALUE') = 'int'

  else
       select OBJECTNAME
      from dbo.QUERYVIEWRELATIONSHIP    QR
        inner join QUERYVIEWCATALOG QC on QC.ID = QR.RELATEDQUERYVIEWID
        --AlexLa 3.7.12 Adding back in old rootqueryviewid so it doesn't break old customized smart queries.

        where QC.SUBGROUP ='Smart Fields' and ROOTQUERYVIEWID in ('B4F2F892-022D-4CD3-939F-7788DEEA92A3','D6358C7B-C0B4-4AC3-8ACD-48F97EA38814')
        --and (SELECT  DATA_TYPE from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = QC.OBJECTNAME AND COLUMN_NAME='VALUE') = 'int'