UFN_TRANSLATIONTABLE_GRADESCOREINRANGE

Check that grade scores fall within translation table range.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode
@TRANSLATIONTABLEID	uniqueidentifier	IN
@HIGHESTSCOREALLOWED	decimal(14, 2)	IN
@LOWESTSCOREALLOWED	decimal(14, 2)	IN

Definition

Copy



            CREATE function dbo.UFN_TRANSLATIONTABLE_GRADESCOREINRANGE
                (
                    @TRANSLATIONTABLEID uniqueidentifier,
                    @HIGHESTSCOREALLOWED decimal(14,2),
                    @LOWESTSCOREALLOWED decimal(14,2)
                )
            returns bit
            as begin
                -- Assume value is in range

                declare @RETVAL int = 1;

                if (exists (select *
                            from dbo.TRANSLATIONTABLEGRADE ttg
                            where ttg.TRANSLATIONTABLEID = @TRANSLATIONTABLEID
                                and ((ttg.LOWESTSCORE < @LOWESTSCOREALLOWED) 
                                    or (ttg.LOWESTSCORE > @HIGHESTSCOREALLOWED)
                                    or (ttg.HIGHESTSCORE < @LOWESTSCOREALLOWED) 
                                    or (ttg.HIGHESTSCORE > @HIGHESTSCOREALLOWED))))
                    set @RETVAL = 0;

                return @RETVAL;
            end