UFN_ANALYTICSPROJECTDISTRIBUTION_GETFREQUENCIES

        create function dbo.UFN_ANALYTICSPROJECTDISTRIBUTION_GETFREQUENCIES
        (
            @ANALYTICSPROJECTID uniqueidentifier,
            @ANALYTICSMODELID uniqueidentifier
        )
        returns table
        as return
        (
            with
            SCORECATEGORYTRANSLATION as
            (
                select
                    SCORECATEGORY,
                    SCORECATEGORYNAME
                from
                    (
                        select 0 as SCORECATEGORY, cast(N'951-1000' as nvarchar(50)) as SCORECATEGORYNAME
                        union all select 1, N'901-950'
                        union all select 2, N'851-900'
                        union all select 3, N'801-850'
                        union all select 4, N'751-800'
                        union all select 5, N'701-750'
                        union all select 6, N'651-700'
                        union all select 7, N'601-650'
                        union all select 8, N'551-600'
                        union all select 9, N'501-550'
                        union all select 10, N'451-500'
                        union all select 11, N'401-450'
                        union all select 12, N'351-400'
                        union all select 13, N'301-350'
                        union all select 14, N'251-300'
                        union all select 15, N'201-250'
                        union all select 16, N'151-200'
                        union all select 17, N'101-150'
                        union all select 18, N'51-100'
                        union all select 19, N'0-50'
                    ) LIKELIHOODSCORECATEGORY
                where
                    @ANALYTICSMODELID in
                    (
                        '3CF4EC5A-63FE-42EA-B70B-7F6CAAE286F1',
                        '3788BA7E-E7DC-4A6E-93C9-F2245B26A13B',
                        'DEF85E09-E51A-4EED-B8AF-0763272A5593',
                        'FEB5BE0E-3B4F-45E1-A3E2-26F4372DEE96',
                        'CE8C3F19-6B9A-4852-AB3C-3765F48578F7',
                        'B2C12F11-3C63-4077-ADD0-C976A905B07C',
                        '06776DBB-E33A-45A2-B1DE-972B626169DC',
                        '64111AFB-850D-4407-B403-948F0CD8BE25',
                        '2018E9DB-F837-4CC0-BFC9-E72E5E63ACB5'                    
                    )

                union all

                select
                    SUGGESTEDMEMBERSHIPLEVEL.SCORE,
                    SUGGESTEDMEMBERSHIPLEVEL.RANGE
                from
                    dbo.SUGGESTEDMEMBERSHIPLEVEL
                where
                    @ANALYTICSMODELID = 'A4BACAA3-8EE4-4476-B359-428E582C42AE'

                union all

                select
                    TARGETGIFTRANGE.SCORE,
                    TARGETGIFTRANGE.RANGE
                from
                    dbo.TARGETGIFTRANGE
                where
                    @ANALYTICSMODELID = 'CA0A6B61-2201-482F-AE8D-C6AE6852C318'

                union all

                select
                    WEALTHESTIMATORRATING.SCORE,
                    WEALTHESTIMATORRATING.RANGE
                from
                    dbo.WEALTHESTIMATORRATING
                where
                    @ANALYTICSMODELID = '4D03C579-7461-42AE-8445-442D510B6151'

            )
            select
                ANALYTICSPROJECTDISTRIBUTION.SCORECATEGORY,
                ANALYTICSPROJECTDISTRIBUTION.FREQUENCY,
                SCORECATEGORYTRANSLATION.SCORECATEGORYNAME
            from
                dbo.ANALYTICSPROJECTDISTRIBUTION
                inner join SCORECATEGORYTRANSLATION on ANALYTICSPROJECTDISTRIBUTION.SCORECATEGORY = SCORECATEGORYTRANSLATION.SCORECATEGORY
            where
                ANALYTICSPROJECTDISTRIBUTION.ANALYTICSPROJECTID = @ANALYTICSPROJECTID
                and ANALYTICSPROJECTDISTRIBUTION.ANALYTICSMODELID = @ANALYTICSMODELID
        )