UFN_ANALYTICSMODEL_GETANALYTICSMODELS

CREATE function dbo.UFN_ANALYTICSMODEL_GETANALYTICSMODELS()
returns table
as return
    (
        with
        SCORECATEGORYTRANSLATION as
        (
            select
                LIKELIHOODSCORECATEGORYIDS.ID,
                LIKELIHOODSCORECATEGORY.SCORECATEGORYMIN,
                LIKELIHOODSCORECATEGORY.SCORECATEGORYMAX
            from
                (
                    select cast('3CF4EC5A-63FE-42EA-B70B-7F6CAAE286F1' as uniqueidentifier) as ID
                    union all select '3788BA7E-E7DC-4A6E-93C9-F2245B26A13B'
                    union all select 'DEF85E09-E51A-4EED-B8AF-0763272A5593'
                    union all select 'FEB5BE0E-3B4F-45E1-A3E2-26F4372DEE96'
                    union all select 'CE8C3F19-6B9A-4852-AB3C-3765F48578F7'
                    union all select 'B2C12F11-3C63-4077-ADD0-C976A905B07C'
                    union all select '06776DBB-E33A-45A2-B1DE-972B626169DC'
                    union all select '64111AFB-850D-4407-B403-948F0CD8BE25'
                    union all select '2018E9DB-F837-4CC0-BFC9-E72E5E63ACB5'
                ) LIKELIHOODSCORECATEGORYIDS,
                (
                    select 0 as SCORECATEGORYMIN, 19 as SCORECATEGORYMAX
                ) LIKELIHOODSCORECATEGORY

            union 

            select
                'A4BACAA3-8EE4-4476-B359-428E582C42AE',
                (select top 1 SCORE from dbo.SUGGESTEDMEMBERSHIPLEVEL order by SCORE asc),
                (select top 1 SCORE from dbo.SUGGESTEDMEMBERSHIPLEVEL order by SCORE desc)
            from
                dbo.SUGGESTEDMEMBERSHIPLEVEL

            union 

            select
                'CA0A6B61-2201-482F-AE8D-C6AE6852C318',
                (select top 1 SCORE from dbo.TARGETGIFTRANGE order by SCORE asc),
                (select top 1 SCORE from dbo.TARGETGIFTRANGE order by SCORE desc)
            from
                dbo.TARGETGIFTRANGE

            union 

            select
                '4D03C579-7461-42AE-8445-442D510B6151',
                (select top 1 SCORE from dbo.WEALTHESTIMATORRATING order by SCORE asc),
                (select top 1 SCORE from dbo.WEALTHESTIMATORRATING order by SCORE desc)
            from
                dbo.WEALTHESTIMATORRATING

        )
        select
            ANALYTICSMODEL.ID,
            ANALYTICSMODEL.NAME,
            SCORECATEGORYTRANSLATION.SCORECATEGORYMIN,
            SCORECATEGORYTRANSLATION.SCORECATEGORYMAX
        from
            dbo.ANALYTICSMODEL
            inner join SCORECATEGORYTRANSLATION on SCORECATEGORYTRANSLATION.ID = ANALYTICSMODEL.ID
    )