USP_REVENUE_SPLIT_DATALIST_GETDATA

            create procedure dbo.USP_REVENUE_SPLIT_DATALIST_GETDATA
            (
                @ID uniqueidentifier
            )
            as
                set nocount on;

                select
                    [SPLITS].ID,
                    dbo.UFN_DESIGNATION_BUILDNAME([SPLITS].DESIGNATIONID) as 'Designation',
                    [SPLITS].AMOUNT
                from dbo.REVENUESPLIT as [SPLITS] 
                where [SPLITS].REVENUEID = @ID
                order by [SPLITS].ID;