select    CONVERT(VARCHAR, dateadd(day, -(day(getdate()-1)), getdate()),  23) as thismonth
,CONVERT(VARCHAR, dateadd(month, 1...