Home Forums SQL Server 2012 SQL Server 2012 - T-SQL computed column in view RE: computed column in view
asiaindian
SSCrazy
Points: 2493
More actions
February 21, 2013 at 8:36 am
#1590001
Could you please recheck the CASE statement...I think it should be..
-- [Jourprod] AS
CASE WHEN heure_passage BETWEEN '00:00:00' and '05:59:59' THEN day(jour_passage) -2
ELSE day([date_passage]) -1
END AS [Jourprod]