Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks
SELECT dbo.IM_ITEM.ITEM_NO, dbo.IM_ITEM.DESCR, dbo.IM_ITEM.CATEG_COD, dbo.IM_ITEM.SUBCAT_COD, TOT_QTY_SOLD.ITEM_NO AS Expr1, TOT_QTY_SOLD.WEEK1_QTY_SOLD FROM dbo.IM_ITEM LEFT OUTER JOIN (SELECT ITEM_NO, CASE WHEN CAST([PS_TKT_HIST_LIN.BUS_DAT Start Date] AS DATE) < CAST(GETDATE AS DATE) AND CAST([BUS_DAT Start Date] AS DATE) > CAST(GETDATE() - 7 AS DATE) THEN 'Y' ELSE 'N' END AS WEEK1_QTY_SOLD FROM dbo.PS_TKT_HIST_LIN GROUP BY ITEM_NO, BUS_DAT) AS TOT_QTY_SOLD ON dbo.IM_ITEM.ITEM_NO = TOT_QTY_SOLD.ITEM_NO
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.