CASE WHEN shipdate is NULL AND orderdate < DATEADD( dd, -7, GETDATE()) THEN 3 WHEN shipdate is NOT NULL THEN 2 ELSE 1 END
Wednesday, August 27, 2014
Computed Columns and CASE SQL Server
Subscribe to:
Posts (Atom)
CASE WHEN shipdate is NULL AND orderdate < DATEADD( dd, -7, GETDATE()) THEN 3 WHEN shipdate is NOT NULL THEN 2 ELSE 1 END