I assumed that too and got it right, but why not make the question match the answer:

Bill needs to show the day of the week for today's date on a...

Silly premise for the question, since it would require that the highest sales always occur on the current day.  Just don't try rerunning the report

I think you can remove leading tab(s) directly within a SELECT, without any CASE or loop, for example:

DECLARE @tabPattern VARCHAR(8)

SET @tabPattern = '%[^' + CHAR(9) + ']%'

DECLARE @tabRemove VARCHAR(200)

SET @tabremove...

I would prefer simply:

CHECK(minit LIKE '[ A-Z]')

Why split it into two checks?

You do understand that multiple CASE conditions could be true for the same value and that a single value could be added to every total?

For example, if cas_lbs...