selectconvert(varchar(10),dateadd(DAY,t2.number,t1.day),120)dayfrom(select(SELECTLEFT(CONVERT(varchar(12),DATEADD(MONTH,0,GETDATE()),23),7))+'-01'day) t1,(select number from MASTER..spt_values WHERETYPE='P'AND number>=0and number<=31) t2
whereconvert(varchar(10),dateadd(DAY,t2.number,t1.day),120)like(SELECTLEFT(CONVERT(varchar(12),DATEADD(MONTH,0,GETDATE()),23),7))+'%'