-- end of current month
SELECT DATEADD(mm,DATEDIFF(mm,0,GETDATE())+1,-1)
-- end of last month
SELECT DATEADD(mm,DATEDIFF(mm,0,GETDATE())+0,-1)
-- end of next month
SELECT DATEADD(mm,DATEDIFF(mm,0,GETDATE())+2,-1)