--First Day of this Month
select DATEADD(mm, DATEDIFF(mm,0,getdate()), 0)
vamsikrishnacheruku (3/10/2014)
hai i want to get the first date and weekday of every month in a year .1/jan/2014, monday
1/feb/2014,thrusday
, ,
,,
,,
,,,
,,,
,,
1/nov/2014, thrusday
1/dec/2014, friday
like this output should be