MSSQL - from today upto end of the month

[met0555]

Hi,

I currently use the following code to select records of the current month and year.

SELECT * FROM x where  DATEADD(mm,DATEDIFF(mm,0,dateofservice),0)=DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0)

But now I would only like to show records of the current month but only for current day and future days of the month.
(ex. assuming tday is 03/13/2013

TO SHOW
03/13/2013 ... 03/31/2013

NOT TO SHOW
03/01/2013 ... 03/12/2013

I was wondering if you could give me some tips on how to make this work.

Thanks

[abhijit]

Read this article

[edit]
SELECT DATEADD(DD,-DAY(DATEADD(m,1,GETDATE())),DATEADD(m,1,GETDATE()))

will give you the last day of the month.

[/edit]