Michael Coles: Sergeant SQL : functions

Calculating Holidays in SQL

Mike C — Thu, 25 Feb 2010 21:51:00 GMT

Ask about nearly any kind of SQL-based date calculation in the newsgroups , and you'll likely get responses that include use of an auxiliary calendar table . It's a really good idea, and something I highly recommend to anyone who has to do date-based...(read more)

Please Vote: Windowing Enhancements in SQL Server

Mike C — Fri, 20 Nov 2009 03:45:00 GMT

Back in January 2007, SQL guru Itzik Ben-Gan posted a series of MS Connect enhancement requests concerning windowing function enhancements. Those who have used the ROW_NUMBER() , RANK() , DENSE_RANK() , and NTILE() functions on SQL 2005 and 2008, you...(read more)