CASE WHEN last_name IS NULL THEN '' ELSE ' '+last_name END or ,CASE WHEN qb.style IS NULL THEN '' ELSE ( SELECT sum(qbs.sold_qty) FROM [SL_h].[dbo].[slbj_sales] AS qbs )

https://stackoverflow.com/questions/3237646/t-sql-case-clause-how-to-specify-when-null

,CASE WHEN qb.style IS NULL THEN 0 ELSE ( SELECT ISNULL(sum(qbs.sold_qty),0) FROM [SL_h].[dbo].[slbj_sales] AS qbs WHERE qbs.date > CONVERT(VARCHAR(8), GETDATE() - 360, 112) AND qbs.av0_style = qb.style ) END 04.04.23

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024