USP_OLAP_GETELIGIBLESMARTFIELDS_FORQV

CREATE procedure dbo.USP_OLAP_GETELIGIBLESMARTFIELDS_FORQV(@OLAPDATASOURCEID uniqueidentifier)
as
begin

    select distinct
        sf.[ID] as [SMARTFIELDID],
        sf.[NAME] as [SMARTFIELDNAME],
        tc.[TABLENAME] as [SMARTFIELDTABLENAME],
        sf.[USEVALUEGROUP],
        sf.[CURRENCYID],
        sc.[DATATYPECODE],        
        ort.[OLAPSMARTFIELDTABLESCHEMA],
        ort.[OLAPSMARTFIELDTABLENAME],
        ort.[OLAPSMARTFIELDRECORDIDCOLUMN],
        ort.[OLAPSMARTFIELDVALUECOLUMN],
        ort.[OLAPSMARTFIELDVALUEGROUPCOLUMN],
        ort.[OLAPSMARTFIELDIDCOLUMN],
        rt.[NAME] as [RECORDTYPENAME],
        rt.[ID] as [RECORDTYPEID],    
        ds.[MARTKEY]    
    from dbo.[SMARTFIELD] sf
    inner join dbo.[SMARTFIELDCATALOG] sc on sf.[SMARTFIELDCATALOGID] = sc.[ID]  
    inner join dbo.[OLAPDATASOURCESMARTFIELD] osf on sf.[ID] = osf.[SMARTFIELDID]
    inner join dbo.[OLAPDATASOURCERECORDTYPE] ort on ort.[RECORDTYPEID] = sc.[RECORDTYPEID]
    inner join dbo.[RECORDTYPE] rt on ort.[RECORDTYPEID] = rt.[ID]
    inner join dbo.[OLAPDATASOURCE] ds on ds.[ID] = @OLAPDATASOURCEID
    inner join dbo.[TABLECATALOG] tc on tc.[ID] = sf.[TABLECATALOGID]
    inner join dbo.[QUERYVIEWCATALOG] qv on qv.[RECORDTYPEID] = sc.[RECORDTYPEID] and ds.[MARTKEY] = qv.[MARTKEY]
    where sc.DATATYPECODE <> 5 --Record


end