Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
declare @StartDate date = '2016-10-01', @EndDate date = '2017-11-01', @ClientID int = 3282 select p.ProductName, u.UOM, x.TimesOrdered as [Times Ordered], x.TotalQuantity as [Total Qty], x.TotalPrice as [Total Price], x.AverageQuantity as [Avg Qty], x.AveragePrice as [Avg Price] from ( select od.ProductID, od.UOMID, count(1) as TimesOrdered, sum(od.Quantity) as TotalQuantity, sum(od.Quantity * od.Price) as TotalPrice, avg(od.Quantity) as AverageQuantity, avg(od.Price) as AveragePrice from Orders o join OrderDetails od on o.OrderID = od.OrderID join ProductUOMs pu on pu.ProductID = od.ProductID and pu.UOMID = od.UOMID where ClientID = @ClientID and o.Active = 1 and o.Status = 1 and od.Active = 1 and o.OrderDate between @StartDate and @EndDate group by od.ProductID, od.UOMID ) x join Products p on x.ProductID = p.ProductID join UnitsOfMeasure u on x.UOMID = u.UOMID order by p.ProductName, u.UOM
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.