What about performance using this methodology?

There are many articles about using "SARG"able methodologies which allow indexes to operate correctly.

http://www.databasejournal.com/features/mssql/article.php/1436301

http://www.windowsitpro.com/SQLServer/Article/ArticleID/42349/42349.html

It appears that the JOIN portion is SARGable, but how do we know for sure since the join seems to now operate onmultiple values?

INNER JOIN

      tb_GradeScale g

      ON(

            s.NumericGrade BETWEEN g.MinNumeric AND g.MaxNumeric

      )

- B