USP_SIMPLEDATALIST_RECOGNITIONLEVELEXCLUDELEVEL

A list of recognition levels for a recognition program excluding the level sent as a parameter. This is used on the Recognition Program Add Form.

Parameters

Parameter	Parameter Type	Mode	Description
@RECOGNITIONPROGRAMID	uniqueidentifier	IN	RECOGNITIONPROGRAMID
@RECOGNITIONLEVELID	uniqueidentifier	IN	RECOGNITIONLEVELID

Definition

Copy



        create procedure dbo.USP_SIMPLEDATALIST_RECOGNITIONLEVELEXCLUDELEVEL
                (
                    @RECOGNITIONPROGRAMID uniqueidentifier,
          @RECOGNITIONLEVELID uniqueidentifier
                )
                as

                    set nocount on;

                    select
                        ID as VALUE,
                        NAME as LABEL
                    from
                        dbo.RECOGNITIONLEVEL
                    where
                        RECOGNITIONPROGRAMID = @RECOGNITIONPROGRAMID
            and (ID <> @RECOGNITIONLEVELID or @RECOGNITIONLEVELID is null)
                        and RECOGNITIONLEVEL.ISACTIVE='True' 
                    order by NAME