Monthly Archives: March 2010

First Day of Current Month

SELECT DATEADD( mm, DATEDIFF( mm, 0, GETDATE() ), 0 ) AS FirstOfMonth Since I always manage to get the syntax wrong from memory, above is a SELECT statement that will return the first day of the current month. Edit: As … Continue reading

Posted in SQL Toolbox | Tagged , , | 1 Comment

XML Modification

XML Modification for fun and profit Continue reading

Posted in SQL Server Development | Tagged , , | Leave a comment