UFN_REVENUESPLIT_GETTOP10RECOGNITIONCREDITSINONEROW

            create function dbo.UFN_REVENUESPLIT_GETTOP10RECOGNITIONCREDITSINONEROW
            (
                @REVENUESPLITID uniqueidentifier
            )
            returns table
            as
            return
            (
                select
                    RECOGNITIONCREDIT1.RECIPIENT as RECIPIENT1,
                    RECOGNITIONCREDIT1.AMOUNT as AMOUNT1,
                    RECOGNITIONCREDIT1.TYPE as TYPE1,
                    RECOGNITIONCREDIT1.EFFECTIVEDATE as EFFECTIVEDATE1,

                    RECOGNITIONCREDIT2.RECIPIENT as RECIPIENT2,
                    RECOGNITIONCREDIT2.AMOUNT as AMOUNT2,
                    RECOGNITIONCREDIT2.TYPE as TYPE2,
                    RECOGNITIONCREDIT2.EFFECTIVEDATE as EFFECTIVEDATE2,

                    RECOGNITIONCREDIT3.RECIPIENT as RECIPIENT3,
                    RECOGNITIONCREDIT3.AMOUNT as AMOUNT3,
                    RECOGNITIONCREDIT3.TYPE as TYPE3,
                    RECOGNITIONCREDIT3.EFFECTIVEDATE as EFFECTIVEDATE3,

                    RECOGNITIONCREDIT4.RECIPIENT as RECIPIENT4,
                    RECOGNITIONCREDIT4.AMOUNT as AMOUNT4,
                    RECOGNITIONCREDIT4.TYPE as TYPE4,
                    RECOGNITIONCREDIT4.EFFECTIVEDATE as EFFECTIVEDATE4,

                    RECOGNITIONCREDIT5.RECIPIENT as RECIPIENT5,
                    RECOGNITIONCREDIT5.AMOUNT as AMOUNT5,
                    RECOGNITIONCREDIT5.TYPE as TYPE5,
                    RECOGNITIONCREDIT5.EFFECTIVEDATE as EFFECTIVEDATE5,

                    RECOGNITIONCREDIT6.RECIPIENT as RECIPIENT6,
                    RECOGNITIONCREDIT6.AMOUNT as AMOUNT6,
                    RECOGNITIONCREDIT6.TYPE as TYPE6,
                    RECOGNITIONCREDIT6.EFFECTIVEDATE as EFFECTIVEDATE6,

                    RECOGNITIONCREDIT7.RECIPIENT as RECIPIENT7,
                    RECOGNITIONCREDIT7.AMOUNT as AMOUNT7,
                    RECOGNITIONCREDIT7.TYPE as TYPE7,
                    RECOGNITIONCREDIT7.EFFECTIVEDATE as EFFECTIVEDATE7,

                    RECOGNITIONCREDIT8.RECIPIENT as RECIPIENT8,
                    RECOGNITIONCREDIT8.AMOUNT as AMOUNT8,
                    RECOGNITIONCREDIT8.TYPE as TYPE8,
                    RECOGNITIONCREDIT8.EFFECTIVEDATE as EFFECTIVEDATE8,

                    RECOGNITIONCREDIT9.RECIPIENT as RECIPIENT9,
                    RECOGNITIONCREDIT9.AMOUNT as AMOUNT9,
                    RECOGNITIONCREDIT9.TYPE as TYPE9,
                    RECOGNITIONCREDIT9.EFFECTIVEDATE as EFFECTIVEDATE9,

                    RECOGNITIONCREDIT10.RECIPIENT as RECIPIENT10,
                    RECOGNITIONCREDIT10.AMOUNT as AMOUNT10,
                    RECOGNITIONCREDIT10.TYPE as TYPE10,
                    RECOGNITIONCREDIT10.EFFECTIVEDATE as EFFECTIVEDATE10
                from
                    dbo.UFN_REVENUESPLIT_GETRECOGNITIONCREDITBYROWNUMBER(@REVENUESPLITID, 1) as RECOGNITIONCREDIT1
                    outer apply dbo.UFN_REVENUESPLIT_GETRECOGNITIONCREDITBYROWNUMBER(@REVENUESPLITID, 2) as RECOGNITIONCREDIT2
                    outer apply dbo.UFN_REVENUESPLIT_GETRECOGNITIONCREDITBYROWNUMBER(@REVENUESPLITID, 3) as RECOGNITIONCREDIT3
                    outer apply dbo.UFN_REVENUESPLIT_GETRECOGNITIONCREDITBYROWNUMBER(@REVENUESPLITID, 4) as RECOGNITIONCREDIT4
                    outer apply dbo.UFN_REVENUESPLIT_GETRECOGNITIONCREDITBYROWNUMBER(@REVENUESPLITID, 5) as RECOGNITIONCREDIT5
                    outer apply dbo.UFN_REVENUESPLIT_GETRECOGNITIONCREDITBYROWNUMBER(@REVENUESPLITID, 6) as RECOGNITIONCREDIT6
                    outer apply dbo.UFN_REVENUESPLIT_GETRECOGNITIONCREDITBYROWNUMBER(@REVENUESPLITID, 7) as RECOGNITIONCREDIT7
                    outer apply dbo.UFN_REVENUESPLIT_GETRECOGNITIONCREDITBYROWNUMBER(@REVENUESPLITID, 8) as RECOGNITIONCREDIT8
                    outer apply dbo.UFN_REVENUESPLIT_GETRECOGNITIONCREDITBYROWNUMBER(@REVENUESPLITID, 9) as RECOGNITIONCREDIT9
                    outer apply dbo.UFN_REVENUESPLIT_GETRECOGNITIONCREDITBYROWNUMBER(@REVENUESPLITID, 10) as RECOGNITIONCREDIT10
            )