Rest in peace, indeed, dear ol' friend.  You were definitely one of the good guys and you are sorely missed.

Well, crud... I resurrected an old "Passport" disk and found my old animated "Death Star" explosion of rebar but the new forum apparently doesn't support animated GIFs.  Had to "settle"...

This will do it for you.  Details are in the comments.

-- DROP TABLE #MyTable
--===== Put the test data into a table.
     -- this...

and sorry regarding

, I was able to figure out how to format the way I...

I'm working with a database where a column that includes duration in terms of minutes is stored as datetime.  The data looks like this.  Note the '1899-12-30' info can...

Welcome back, Barry.  Hope you're doing well.  I still give credit to you for the term "Pseudo Cursor" all the time.

K.  Thanks for the update, Steve.

The server is backed up regularly, but I don't want to have to bother that team if I can do things safely.  I assume I would have to change...

Me too.

If they're not doing regular backups of your databases and transaction log files, you have a serious problem.

Please see the following article...

https://www.sqlservercentral.com/articles/generating-test-data-part-2-generating-sequential-and-random-dates

Next step to consider... these two jobs aren't the only two jobs in this world.

Setting

The most important step is to have a learning/test/experimentation environment you have all to yourself.  The following link contains a "download" button that will provide you with a free copy...

These report periods can overlap; a fiscal quarter will be contained in the range of its fiscal year. I like the MySQL convention of using double zeroes for months and...