UFN_RECOGNITIONLEVELAMOUNT_EXISTSIMILARRECOGNITIONLEVEL

Returns the numbers of rows select from a recognition level amount given a recognition level id.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@RECOGNITIONLEVELAMOUNTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_RECOGNITIONLEVELAMOUNT_EXISTSIMILARRECOGNITIONLEVEL
            (
                @RECOGNITIONLEVELAMOUNTID uniqueidentifier
            )
            returns bit
            with execute as caller
            as    begin
                    if exists
                        (
                         select RLA.RECOGNITIONLEVELID  from dbo.RECOGNITIONLEVELAMOUNT RLA
                         where RLA.RECOGNITIONLEVELID= (select RECOGNITIONLEVELID from dbo.RECOGNITIONLEVELAMOUNT where ID=@RECOGNITIONLEVELAMOUNTID) 
                         and RLA.ID != @RECOGNITIONLEVELAMOUNTID
                        ) return 1;

                    return 0;
            end