SQLServer中计算周

	--本周最大值与最小值、平均值
	DECLARE @WeekMax float,@WeekMin float,@WeekAvg float,@AddDate varchar(20)
	DECLARE @WeekStart int,@WeekEnd int,@WeekCount int,@WeekStr varchar(12),@WeekNum int
	SET @AddDate = CAST(@Year as varchar(4)) + '-' + CAST(@Month as varchar(4)) + '-' + CAST(@Day as varchar(4))
	select @WeekCount=datename(week,@AddDate),@WeekStr=datename(weekday,@AddDate)
	select @WeekNum = case @WeekStr
				When '星期一' THEN 1
				When '星期二' THEN 2
				When '星期三' THEN 3
				When '星期四' THEN 4
				When '星期五' THEN 5
				When '星期六' THEN 6
				ELSE 7
			END
	SET @WeekStart = DATEADD([day],(0-(@WeekNum-1)),@AddDate)
	SET @WeekEnd = DATEADD([day],(7-@WeekNum),@AddDate)

　　

转载于:https://www.cnblogs.com/blackice/p/3307972.html