tag:blogger.com,1999:blog-876791350937229496.post893299234793422255..comments2022-03-30T01:50:24.504+08:00Comments on SQL QnA: 取得下一個週五的日期Hsu, Harryhttp://www.blogger.com/profile/14340005814129176962noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-876791350937229496.post-4009518924784671832018-05-01T00:46:04.414+08:002018-05-01T00:46:04.414+08:00下個週五的取得 → S.Target + 7 - (DATEPART(DW,S.Target) + ...下個週五的取得 → S.Target + 7 - (DATEPART(DW,S.Target) + 1) % 7 <br />可比原來減少一個運算!南無阿彌陀佛https://www.blogger.com/profile/07431259888423828816noreply@blogger.com