Fair point.  I was trying out my solution on a test database that didn't have a prepared Calendar table, so that was my quick hack.  I should have...

Fair point.  I was trying out my solution on a test database that didn't have a prepared Calendar table, so that was my quick hack.  I should have cleaned that...

• This reply was modified 4 years, 2 months ago by  dan.bridgeman.

Here's something that should work for you, using the UserAccount table and values that Steve Collins posited above..

CREATE TABLE UserAccount
    (
   ...

IMHO, there is always a story with the data:  it's an inescapable function of data analysis.  And if you don't tell a story, the listener or reader provides their own...

What you've described is not a scientist, but an engineer. Not that there's anything wrong with that....