SELECT b.[code] ,s.picture ,CAST( CASE WHEN (CONVERT(VARCHAR(8), GETDATE()-90, 112) < enter_date AND web = 1 ) THEN 1 ELSE 0 END AS bit ) AS new_arrival FROM [foo].[dbo].[bar] as b

http://stackoverflow.com/questions/63447/how-to-perform-an-if-then-in-an-sql-select

,IIF(CONVERT(VARCHAR(8), GETDATE()-90, 112) < av0_enter_date AND web = 1,1,0) AS new_arrival 10.06.16

https://msdn.microsoft.com/en-us/library/hh213574%28v=sql.110%29.aspx

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024