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...