USP_MKTSOURCEANALYSISRULEFIELDS_GETDATALIST

CREATE procedure dbo.[USP_MKTSOURCEANALYSISRULEFIELDS_GETDATALIST]
(
  @RECORDSOURCEID uniqueidentifier
)
as
  set nocount on;

  select
    [MKTSOURCEANALYSISRULEFIELDS].[NAME] as [NAME],
    (case [MKTSOURCEANALYSISRULEFIELDS].[ISACTIVE] when 0 then '' else 'RES:Check' end) as [ISACTIVE],
    [MKTSOURCEANALYSISRULEFIELDS].[PURPOSE] as [PURPOSE],
    [MKTSOURCEANALYSISRULEFIELDS].[QUERYVIEWCATALOGID] as [QUERYVIEWCATALOGID],
    [MKTSOURCEANALYSISRULEFIELDS].[SOURCEANALYSISRULEID] as [SOURCEANALYSISRULEID],
    [MKTSOURCEANALYSISRULES].[RECORDSOURCEID] as [RECORDSOURCEID],
    (case
      when exists(select *
                  from sys.indexes i
                  inner join sys.index_columns ic on ic.object_id = i.object_id and ic.index_id = i.index_id
                  inner join sys.columns c on c.object_id = ic.object_id and c.column_id = ic.column_id
                  where i.object_id = object_id('dbo.[' + dbo.[UFN_MKTSOURCEANALYSISRULE_MAKETABLENAME](@RECORDSOURCEID) + ']')
                  and c.[name] = [MKTSOURCEANALYSISRULEFIELDS].[CACHETABLECOLUMNNAME])
      then convert(bit, 1)
      else convert(bit, 0)
     end)  as [INDEXED],
     [MKTSOURCEANALYSISRULEFIELDS].[QUERYABLE] as [QUERYABLE],
     [MKTSOURCEANALYSISRULEFIELDS].[VIEWPATH] as [VIEWPATH],
     [MKTSOURCEANALYSISRULEFIELDS].[QUERYFIELD] as [QUERYFIELD],
     [MKTSOURCEANALYSISRULEFIELDS].[SMARTFIELDID] as [SMARTFIELDID]
  from dbo.[MKTSOURCEANALYSISRULEFIELDS]
  inner join dbo.[MKTSOURCEANALYSISRULES] on [MKTSOURCEANALYSISRULEFIELDS].[SOURCEANALYSISRULEID] = [MKTSOURCEANALYSISRULES].[ID]
  left join dbo.[QUERYVIEWCATALOG] on [QUERYVIEWCATALOG].[OBJECTNAME] = [MKTSOURCEANALYSISRULEFIELDS].[DBOBJECTNAME]
  where [MKTSOURCEANALYSISRULES].[RECORDSOURCEID] = @RECORDSOURCEID;

  return 0;