22,207
社区成员
发帖
与我相关
我的任务
分享
update b set b.price=a.price from b inner join a on
b.P_no=a.P_no and b.date between a.s_date and a.end_date
WITH price(P_no,price,s_date,end_date) AS
(
SELECT 1,10.00,CONVERT(DATETIME,'11/01/2015'),CONVERT(DATETIME,'11/30/2015')
UNION
SELECT 1,15.00,'12/01/2015','12/31/2015'
)
SELECT * FROM price AS p WHERE DATEDIFF(d,p.s_date,GETDATE())>=0 AND DATEDIFF(d,GETDATE(),p.end_date)>=0
-- or WHERE GETDATE() BETWEEN p.s_date AND p.end_date