;WITH POTemp as ( SELECT VendorID, SUM(TotalDue) as VendorTotal FROM Purchasing.PurchaseOrderHeader WHERE where OrderDate BETWEEN '1-1-2008' AND '12-31-2008' GROUP BY VendorID) select Vend.Name, VendorTotal from Purchasing.Vendor as Vend left outer join POTemp on Vend.BusinessEntityID = POTemp.VendorID order by VendorTotal descIs more readable than
select Vend.Name, SUM(TotalDue) as VendorTotal from Purchasing.Vendor as Vend left outer join Purchasing.PurchaseOrderHeader AS POH on Vend.BusinessEntityID = POH.VendorID AND POH.OrderDate BETWEEN '1-1-2008' AND '12-31-2008' group by Vend.Name order by VendorTotal descor
select Vend.Name, (SELECT SUM(TotalDue) FROM Purchasing.PurchaseOrderHeader WHEREVend.BusinessEntityID = VendorID AND OrderDate BETWEEN '1-1-2008' AND '12-31-2008') as VendorTotal from Purchasing.Vendor as Vend order by VendorTotal desc?