USP_SIMPLEDATALIST_BATCHSPONSORSHIP

CREATE procedure dbo.USP_SIMPLEDATALIST_BATCHSPONSORSHIP ( 
    @CONSTITUENTID uniqueidentifier)
as
    set nocount on;

    select     
        S.ID as VALUE, 
        coalesce((select top 1 NAME from SPONSORSHIPOPPORTUNITYCHILD where ID=S.SPONSORSHIPOPPORTUNITYID),
                                                (select NAME from SPONSORSHIPOPPORTUNITYPROJECT where ID = S.SPONSORSHIPOPPORTUNITYID)) as LABEL
    from 
        dbo.FINANCIALTRANSACTIONLINEITEM
        inner join SPONSORSHIP S on S.REVENUESPLITID = FINANCIALTRANSACTIONLINEITEM.ID
        inner join FINANCIALTRANSACTION on FINANCIALTRANSACTION.ID = FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID
    where 
        FINANCIALTRANSACTION.CONSTITUENTID = @CONSTITUENTID
        and S.ISMOSTRECENTFORCOMMITMENT = 1
        and S.STATUSCODE = 1