單純、幸福

set datefirst 1 -->預設起始日為禮拜一

select (CAST((select (((select datepart(DAYOFYEAR, getdate())) - (select datepart(DAYOFYEAR, (SELECT  dateadd(ms,-3,DATEADD(mm,  DATEDIFF(mm,0,getdate()),0))))) + (select datepart(weekday, '2014/07/01')-1)) / 7) +1 ) as char(1))) -->查出第幾個禮拜

select (CAST((select (((select datepart(DAYOFYEAR, getdate())) - (select datepart(DAYOFYEAR, (SELECT  dateadd(ms,-3,DATEADD(mm,  DATEDIFF(mm,0,getdate()),0))))) + (select datepart(weekday, '2014/07/01')-1)) % 7))as char(1))) -->查出禮拜幾