USP_DATALIST_SOURCEANALYSISRULEFIELDS

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

  select
    [MKTSOURCEANALYSISRULEFIELDS].[NAME],
    (case [MKTSOURCEANALYSISRULEFIELDS].[ISACTIVE] when 0 then 'RES:x_16' else 'RES:Check' end) as [STATUS],
    [MKTSOURCEANALYSISRULEFIELDS].[PURPOSE],
    [MKTSOURCEANALYSISRULEFIELDS].[QUERYVIEWCATALOGID],
    [MKTSOURCEANALYSISRULEFIELDS].[SOURCEANALYSISRULEID],
    [MKTSOURCEANALYSISRULES].[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]
  from dbo.[MKTSOURCEANALYSISRULEFIELDS]
  inner join dbo.[MKTSOURCEANALYSISRULES] on [MKTSOURCEANALYSISRULEFIELDS].[SOURCEANALYSISRULEID] = [MKTSOURCEANALYSISRULES].[ID]
  where [MKTSOURCEANALYSISRULES].[RECORDSOURCEID] = @RECORDSOURCEID;

  return 0;