How will you find last sunday of a month in sql 2000?
SELECT DATEADD(day,DATEDIFF(day,'19000107',DATEADD(month,DATEDIFF(MONTH,0,GETDATE() /*YourValuehere*/),30))/7*7,'19000107')
Edit: A correct, final, working answer from my colleague.
1.4m articles
1.4m replys
5 comments
57.0k users