USP_OLAPCONFIG_GETSARFIELDS

CREATE PROCEDURE dbo.USP_OLAPCONFIG_GETSARFIELDS
as

declare @RECORDSOURCEID uniqueidentifier = dbo.UFN_MKTRECORDSOURCE_GETFIRSTBBECRECORDSOURCEID()
declare @SARTABLENAME nvarchar(255) = dbo.[UFN_MKTSOURCEANALYSISRULE_MAKETABLENAME](@RECORDSOURCEID);

select 
  sarf.[ID],
  @SARTABLENAME [SARTABLENAME],   
  sarf.[NAME] [NAME], 
  case sarf.[ISCUSTOM]
    when 0 then sarf.[NAME]
    when 1 then sarf.[QUERYFIELD]
  end [COLUMN_NAME],
  case col.[DATA_TYPE]
    when 'bit' then 0
    when 'int' then 1
    when 'money' then 2
    when 'datetime' then 3
    when 'nvarchar' then 4
    else 0
  end [DATATYPE]
from dbo.MKTSOURCEANALYSISRULEFIELDS sarf
inner join dbo.MKTSOURCEANALYSISRULES sar on sarf.SOURCEANALYSISRULEID = sar.ID
left join INFORMATION_SCHEMA.COLUMNS col on col.[TABLE_NAME] = sarf.[DBOBJECTNAME] and col.[COLUMN_NAME] = sarf.[QUERYFIELD]
where sar.RECORDSOURCEID = @RECORDSOURCEID and col.[DATA_TYPE] not in ('money');