USP_SIMPLEDATALIST_BENEFIT_REVENUE

create procedure dbo.USP_SIMPLEDATALIST_BENEFIT_REVENUE (@REVENUEID uniqueidentifier = null) 
            as
                begin

                select REVENUEBENEFIT.ID as VALUE, BENEFIT.NAME as LABEL 
                from REVENUEBENEFIT 
                join BENEFIT
                    on REVENUEBENEFIT.BENEFITID = BENEFIT.ID
                where REVENUEBENEFIT.REVENUEID  = @REVENUEID;

                end