displaymonthasacalendarusingsql

---sql server 2005 顯示一個月的數據，如果沒有空的也要顯示出來declare @T table([geovinddate] Datetime,[workcontent] nvarchar(8),[worker] nvarchar(50))Insert @Tselect '2012-8-11',N'遲到','geovindu' union allselect '2012-8-12',N'早退','geovin

---sql server 2005 顯示一個月的數據，美国空间，如果沒有空的也要顯示出來 declare @T table([geovinddate] Datetime,[workcontent] nvarchar(8),[worker] nvarchar(50)) Insert @T select '2012-8-11',N'遲到','geovindu' union all select '2012-8-12',N'早退','geovin' ;with Date as (select cast('2012-08-01' as datetime) Date union all select Date+1 from Date where Date+1<'2012-9-1') select cast(a.Date as varchar(50))+' '+ DATENAME(weekday, a.Date), [workcontent]=isnull([workcontent],''),[worker]=isnull([worker],'') from Date a left join @T b on a.Date=b.[geovinddate] ---sql server 2005:display current month as a calendar using sql ;with monthDates as ( select DATEADD(month, datediff(month, 0, getdate()),0) as d ,DATEPART(week, DATEADD(month, datediff(month, 0, getdate()),0)) as w union all select DATEADD(day, 1, d) ,DATEPART(week, DATEADD(day, 1, d)) from monthDates where d