sql server 打印日历

闲的没事，弄了一个sql打印日历，做个记录。

SET NOCOUNT ON
SET DATEFIRST 1


DECLARE @sDate DATE,@eDate DATE,@Year INT,@Month INT,@Weeks INT,
@tmpDate DATE,@Week INT,@Weekday NVARCHAR(3)
SELECT @sDate=DATEADD(year,-3,GETDATE()),@eDate=GETDATE()


IF object_id('tempdb..#tmpDate')IS NOT NULL
DROP TABLE #tmpDate
CREATE TABLE #tmpDate(
	[Date] DATE,
	[Year] INT,
	[Month] INT,
	[Week] INT,
	[Weekday] NVARCHAR(3),
	Weeks INT,
	WeeksOrderBy VARCHAR(10)
)
WHILE(@sDate<=@eDate)
BEGIN
	IF(@Month!=month(@sDate))
	BEGIN
		SET @tmpDate=@sDate
		INSERT INTO #tmpDate(Year,Month,Weeks,[Week],[Weekday],WeeksOrderBy)
		VALUES(@year,@Month,@Weeks,@Week,@Weekday,CONVERT(VARCHAR(3),@Weeks)+'cr')
	end
	
	SELECT @year=year(@sDate),@Month=month(@sDate),@Weeks=DATENAME(w