Finding Recurring Dates in MSSQL using HAVING

Posted At : March 30, 2007 9:44 AM | Posted By : Paul Marcotte
Related Categories: T-SQL,MSSQL

Recently, I automated a manual billing process for recurring invoices. In order to batch process the job, I decided to use a stored procedure that gets the billing details for all recurring invoices by date.

MSSQL date functions DATEADD, DATEDIFF and DATEPART take some getting used to, but are well documented and (once understood) made the query nice and light. What I missed was the fact that not all months are created equal.

[More]

Comments (0) | Print | Send | del.icio.us | Digg It! | Linking Blogs | 1065 Views
Comments

There are no comments for this entry.

[Add Comment]
BlogCFC was created by Raymond Camden. This blog is running version 5.9. Contact Blog Owner