27,579
社区成员
发帖
与我相关
我的任务
分享
WITH CTE AS(
SELECT 1'ID','A' 'name',1'productid',CAST('2014-09-09'AS DATETIME)'time'
UNION ALL SELECT 2,'B',2,'2014-09-09'
)
SELECT
name
,CASE productid WHEN 1 THEN (CASE WHEN DATEADD(day,2,[time])<GETDATE() THEN '失效' ELSE '有效' END)
WHEN 2 THEN (CASE WHEN DATEADD(year,1,[time])<GETDATE() THEN '失效' ELSE '有效' END) END
FROM
CTE
CREATE TABLE ... (
...,
result AS CASE WHEN GetDate() < time THEN 1 ELSE 0 END
)