The Tally Table appears to be what I am looking to do.

I will verify some of the results but initial return values look okay.

So the code has several "SELECT 1 UNION ALL"...how do you know how many to use?

The code also uses "SELECT TOP 50 ROW_NUMBER()"....how do you know to use 50?

Thanks again for the help!