UFN_TRANSLATIONTABLEGRADE_SCOREINRANGE

Check that grade scores fall within translation table range.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode
@TRANSLATIONTABLEID	uniqueidentifier	IN
@HIGHESTSCORE	decimal(14, 2)	IN
@LOWESTSCORE	decimal(14, 2)	IN

Definition

Copy



            CREATE function dbo.UFN_TRANSLATIONTABLEGRADE_SCOREINRANGE
                (
                    @TRANSLATIONTABLEID uniqueidentifier,
                    @HIGHESTSCORE decimal(14,2),
                    @LOWESTSCORE decimal(14,2)
                )
            returns bit
            as begin
                -- Assume value is in range

                declare @RETVAL int = 1;

                select @RETVAL = case when 
                            (@LOWESTSCORE < TRANSLATIONTABLE.LOWESTSCOREALLOWED) 
                         or (@LOWESTSCORE > TRANSLATIONTABLE.HIGHESTSCOREALLOWED)
                         or (@HIGHESTSCORE < TRANSLATIONTABLE.LOWESTSCOREALLOWED) 
                         or (@HIGHESTSCORE > TRANSLATIONTABLE.HIGHESTSCOREALLOWED)
                    then 0 else 1 end
                from dbo.TRANSLATIONTABLE
                where TRANSLATIONTABLE.ID = @TRANSLATIONTABLEID

                return @RETVAL;
            end