UFN_REVENUESPLITDESIGNATION_GETLOOKUPID

            create function dbo.UFN_REVENUESPLITDESIGNATION_GETLOOKUPID(@ID uniqueidentifier) returns nvarchar(512) WITH EXECUTE as CALLER
            as
            begin
                declare @LOOKUPID nvarchar(512)
                select @LOOKUPID = USERID 
                from dbo.REVENUESPLIT
                inner join dbo.DESIGNATION on REVENUESPLIT.DESIGNATIONID = DESIGNATION.ID
                where REVENUESPLIT.ID = @ID
                return @LOOKUPID
            end