Joel
4Penny.net
Points: 10550

10/13/2011 4:18:19 PM

SQL Stuff

* This article, and all our great SQL (General) documentation, Is available on the SQL (General) menu

Not 'stuff' as in 'Where's my stuff'... 'Stuff' as in the T-SQL function.

http://msdn.microsoft.com/en-us/library/ms188043.aspx

I've tried for years to find a good use for this function, and I've finally found one

I frequently need to convert a date to the first of the month. Normally I use several steps, first calculating the day of the month and then subtracting that number from the date using DATEADD. But now...

4Penny.net
Version: Unknown or N/A
Section: SQL Scripts
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3