Microsoft Logo

Microsoft SQL Sample Code

SQL Function for Displaying all Dates between a Start and End Date

This sql function is very useful for returning every date between a start and end date you pass to the function. The code below will show you how to accomplish that.

A sample call to this function would be:
Select * From dbo.DateRange('d','10/1/18','10/29/18')
which would return:

If you need any help implementing this sql or modifications made for your needs, please Click Here to get a free quote for your Microsoft SQL Development needs. 

Click Here to learn more about the WSI quoting process.

About Us

WSI is a small business and a leading provider of custom SQL Server/Azure programming and database solutions for government entities, Fortune 1000 companies, and emerging businesses. We are your custom SQL Server/Azure development experts.