This one will do the trick with just three instructions (and no string conversions which are best avoided):

SELECT

"LastDayOfMonth" = DatePart(day, DateAdd(month, DateDiff(month, -1, GetDate()), -1))

Won't the query cost for

select dbo.datefloor(getdate(),'dd')

be a lot higher than say

select convert(datetime, convert(char(10), getdate(), 120))

?

SELECT [alias] FROM [master].[dbo].[syslanguages]

Or you can use lcid if you modify the procedure slightly.

Very nice indeed, except maybe that the week numbers are incorrect, or at least does not comply with the internationell standard ISO 8601 (1972). For example, the year 2006 week...