Thank you! It's working now. And now I'll delve into the T-SQL syntax documentation to figure out how it works! The "with" and "over" are new to me so this...

In trying the code, I got stuck immediately with a syntax error in the last line of the vTally view definition: Incorrect syntax near ')'

the parens seem to match up,...