USP_SIMPLEDATALIST_CONSTITUENTRECOGNITIONDECLINED

Lists all of the levels for a recognition program given a constituent recognition ID, excluding already assigned levels.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTRECOGNITIONID	uniqueidentifier	IN	CONSTITUENTRECOGNITIONID

Definition

Copy



        create procedure dbo.USP_SIMPLEDATALIST_CONSTITUENTRECOGNITIONDECLINED
        (
          @CONSTITUENTRECOGNITIONID uniqueidentifier
        )
        as

                    set nocount on;
          declare @CONSTITUENTID uniqueidentifier;
          declare @RECOGNITIONPROGRAMID uniqueidentifier;

          select @CONSTITUENTID=CONSTITUENTID,
                 @RECOGNITIONPROGRAMID=RECOGNITIONPROGRAMID 
          from dbo.CONSTITUENTRECOGNITION where ID=@CONSTITUENTRECOGNITIONID

            select
                        RECOGNITIONLEVEL.ID as VALUE,
                        RECOGNITIONLEVEL.NAME as LABEL
                    from
                        dbo.RECOGNITIONLEVEL

          where
            RECOGNITIONLEVEL.RECOGNITIONPROGRAMID = @RECOGNITIONPROGRAMID
            and RECOGNITIONLEVEL.ID not in (select RECOGNITIONLEVELID from dbo.CONSTITUENTRECOGNITION where CONSTITUENTRECOGNITION.RECOGNITIONPROGRAMID = @RECOGNITIONPROGRAMID and CONSTITUENTRECOGNITION.CONSTITUENTID = @CONSTITUENTID)


                    order by NAME