• Here's a script to create a time dimension:

    Script to Populate Date Dimension, without Using a Cursor

    I wouldn't stop at the month level. I would create the dimension to the date level. You never know if the requirements for reporting change and this way you'll be ready. And it aren't that many rows.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP