USP_SIMPLEDATALIST_DESIGNATION_APPEAL_OPPORTUNITY

Returns all designations for the given appeal or opportunity.

Parameters

Parameter	Parameter Type	Mode	Description
@APPEALID	uniqueidentifier	IN	Appeal
@OPPORTUNITYID	uniqueidentifier	IN	Opportunity

Definition

Copy



            create procedure dbo.USP_SIMPLEDATALIST_DESIGNATION_APPEAL_OPPORTUNITY(@APPEALID uniqueidentifier = null, @OPPORTUNITYID uniqueidentifier = null) 
            as
                begin

                select DESIGNATION.ID as VALUE, DESIGNATION.USERID as LABEL 
                from dbo.APPEALDESIGNATION
                inner join dbo.DESIGNATION
                    on APPEALDESIGNATION.DESIGNATIONID = DESIGNATION.ID
                where APPEALDESIGNATION.APPEALID = @APPEALID
                union
                select DESIGNATION.ID as VALUE, DESIGNATION.USERID as LABEL 
                from dbo.OPPORTUNITYDESIGNATION
                inner join dbo.DESIGNATION
                    on OPPORTUNITYDESIGNATION.DESIGNATIONID = DESIGNATION.ID
                where OPPORTUNITYDESIGNATION.OPPORTUNITYID = @OPPORTUNITYID;

                end