USP_DATALIST_SPONSORSHIPOPPORTUNITYDESIGNATION

Returns designation information for a given sponsorship opportunity.

Parameters

Parameter	Parameter Type	Mode	Description
@OPPORTUNITYID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



        CREATE procedure dbo.USP_DATALIST_SPONSORSHIPOPPORTUNITYDESIGNATION(@OPPORTUNITYID uniqueidentifier)
          as
          set nocount on;

        select ID, NAME from dbo.DESIGNATION where ID = dbo.UFN_SPONSORSHIPOPPORTUNITY_GETDESIGNATION(@OPPORTUNITYID)