... dy)-1 else datepart (ww, dy) end wk from ( select dateadd(day, -day(getdate())+1, getdate()) dy from t1 ) x union all select dateadd(d, 1, dy), ...
確定! 回上一頁