SDU Tools: Dates in a Period in SQL Server T-SQL

It’s common to need to get a table of all dates between two dates, and in our free SDU Tools for developers and DBAs, we have a function DatesBetween that I’ve previously talked about. But sometimes it’s not a start and end date that you have, it’s a start date and a number of intervals. For example, I might want all the dates for the next three months, or three weeks, or two years. To make that easy, we’ve added a function called DatesInPeriod.

It’s a table-valued function that takes three parameters:

@StartDate is the first date to return @NumberOfIntervals is (no surprise) the number of intervals to include @IntervalCode is a string that can include YEAR, QUARTER, MONTH, WEEK or DAY.

For each date in the number of intervals, it returns a key (an incrementing number for the position of the date within that period), and the date.

You can use our tools as a set or as a great example of how to write functions like these.

Find out more

You can see it in action in the main image above, and in the video here:

Access to SDU Tools is one of the benefits of being an SDU Insider, along with access to our other free tools and eBooks. Please just visit here for more info:

http://sdutools.sqldownunder.com

2020-02-12