USP_SIMPLEDATALIST_DESIGNATION_REVENUE

            CREATE procedure dbo.USP_SIMPLEDATALIST_DESIGNATION_REVENUE(@REVENUEID uniqueidentifier = null) 
            as
                begin

                select DESIGNATION.ID as VALUE, DESIGNATION.USERID as LABEL 
                from dbo.REVENUESPLIT
                inner join dbo.DESIGNATION
                    on REVENUESPLIT.DESIGNATIONID = DESIGNATION.ID
                where REVENUESPLIT.REVENUEID = @REVENUEID;

                end