USP_SIMPLEDATALIST_SPONSORSHIPDESIGNATION

create procedure dbo.USP_SIMPLEDATALIST_SPONSORSHIPDESIGNATION  
(@SPONSORSHIPID uniqueidentifier = null)
as
    select 
        DESIGNATION.ID as VALUE, 
        DESIGNATION.USERID as LABEL 
    from dbo.SPONSORSHIP
    inner join REVENUESPLIT on REVENUESPLIT.ID = SPONSORSHIP.REVENUESPLITID
    inner join dbo.DESIGNATION on DESIGNATION.ID = REVENUESPLIT.DESIGNATIONID
    where SPONSORSHIP.ID = @SPONSORSHIPID
    and SPONSORSHIP.ISMOSTRECENTFORCOMMITMENT = 1