Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.
select I.InventoryID, SUM(CASE WHEN ((getdate()+7) between D.BeginDate and D.EndDate) THEN ROUND (I.Qty,0,0) ELSE 0 END) as 'Column1' SUM(CASE WHEN ((getdate()+14) between D.BeginDate and D.EndDate) THEN ROUND (I.Qty,0,0) ELSE 0 END) as 'Column2' From Inventory I INNER JOIN Date D WHERE D.DateID=I.DateID GROUP BY I.InventoryID
|SQL Query needed to find duplicate entries and remove entry||16||42|
|SQL: launch actions one before the other||10||22|
|SQL Querying data from 3 tables, all with 1 common column||4||33|
|Query group by data in SQL Server - cursor?||3||29|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
16 Experts available now in Live!