USP_DATALIST_SPONSORSHIPOPPORTUNITYISSPONSORED

Datalist that returns a value if the opportunity has been sponsored

Parameters

Parameter	Parameter Type	Mode	Description
@OPPORTUNITYID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_DATALIST_SPONSORSHIPOPPORTUNITYISSPONSORED (
  @OPPORTUNITYID uniqueidentifier)
as
    set nocount on;
    select top 1 1 isSponsored
      from dbo.SPONSORSHIP
     where SPONSORSHIPOPPORTUNITYID = @OPPORTUNITYID
       and STATUSCODE = 1