UFN_NAMINGOPPORTUNITY_REVENUESPLITRECOGNITIONS

            CREATE function dbo.UFN_NAMINGOPPORTUNITY_REVENUESPLITRECOGNITIONS
            (
                @REVENUESPLITID uniqueidentifier
            )
            returns table
            as
            return
            (
                select
                    [NOR].ID as [ID],
                    [NO].ID as [NAMINGOPPORTUNITYID],
                    [NO].NAME as [NAMINGOPPORTUNITYNAME],
                    [NOR].CONSTITUENTID,
                    [NOR].CONSTITUENTNAME as [RECOGNITIONNAME],
                    [NOR].CONSTITUENTNAMEFORMATID [RECOGNITIONNAMEFORMATID],
                    [NOR].CUSTOMNAMEFORMAT as [RECOGNITIONCUSTOMNAME],
                    case when [NOR].STARTDATE = '00000000' then '' else [NOR].STARTDATE end as [RECOGNITIONDATE],
                    case when [NOR].ENDDATE = '00000000' then '' else [NOR].ENDDATE end as [RECOGNITIONENDSDATE],
                    [NOR].QUANTITY as [QUANTITY],
                    [NOR].AMOUNT as [AMOUNT],
                    [NOR].INSCRIPTION as [INSCRIPTION],
                    [NOR].SPECIALREQUEST as [SPECIALREQUEST],
                    [NOR].BASECURRENCYID as [BASECURRENCYID]
                from dbo.NAMINGOPPORTUNITYRECOGNITION as [NOR]
                inner join dbo.NAMINGOPPORTUNITYRECOGNITIONREVENUESPLIT as [NORS] on [NORS].NAMINGOPPORTUNITYRECOGNITIONID = [NOR].ID
                inner join dbo.NAMINGOPPORTUNITY as [NO] on [NO].ID = [NOR].NAMINGOPPORTUNITYID
                where [NORS].REVENUESPLITID = @REVENUESPLITID
            )