T-SQL DATETIME : Last Day of the Month

Some T-SQL tips resources I came across lately:

1. codemag: SELECT vs. SET in T-SQL parameters
2. MSDN: DATETIME internals
3. T-SQL language blog: compiler
4. Angel Saenz-Badillos: connection pooling

And the last one comes from MSSQL server magazine, 09/2004. How can I find the last day of the month ?

SELECT DATEADD(ms, -5, DATEADD(mm, DATEDIFF(m, 0, GETDATE()) + 1, 0))

Related Posts:

• Small T-SQL trick
• How to Insert Millions Records into Database Table
• T-SQL: Update and Output in a Single Query
• MSSQL 2005 beta 2 DE first impressions
• MSSQL Overusability
• SQL Server 2005 Developer Edition Beta 2 (English)
• MSSQL 6.5 Service Pack 5 is Available
• SQL Server 2005 Documentation and Samples
• SQL Express is not ready yet
• Scheduling algorithm using MSSQL sysjobschedules