Thread: Query Distributor Cost by Order

Hello I am in need of some help, I need to Query the total (Actual Cost including ALL Distributors) for orders and get the cost for one poticular Distributor on orders. I see this information if I go into the Order Details page and click on the DISTRIBUTOR link in the frame window, but I can't find this information anywhere in the DB. Can someone help me out.

Thanks
Ryan

Don't know if this is what you're looking for, but it's a starting point:

Code:

SELECT osc.distributorid, d.[name], COUNT(*) AS NumOrders, ROUND(SUM(orderedproductprice),2) AS TotalPrice, SUM(quantity) AS TotalQuantity
FROM orders_shoppingcart AS osc
JOIN distributor AS d ON d.distributorid = osc.distributorid
WHERE orderedproductsku <> 'ADHOCREFUND'
GROUP BY osc.distributorid, d.[name]
ORDER BY d.[name]

Create it as a custom report, or use SQL Server Management Studio