Add up quantities

snufse · July 10th, 2009, 12:18 PM

I need to add gross and net quanties by "load" (which is the bill of lading number). My query still shows multiple rows with same load number (bol number)

Code:

 
select "load",
convert(varchar,Date,101),
branded,
name,
sum(cast(gross as decimal(15,2))), 
sum(cast(net as decimal(15,2)))
from [SFM-TP6000-1].TP6000.dbo.loadcomp as load1
inner join [SFM-TP6000-1].TP6000.dbo.product as prod1 on prod1.product = load1.branded
where load1.branded = 'ULS'

Old Pedant · July 10th, 2009, 03:35 PM

So where, in that, do you ever reference a bill of lading number???

And where is your GROUP BY, in any case.

Since this appears to be SQL Server (because of the "dbo." and the CONVERT with number 101), I can't believe you aren't getting an error message about the lack of GROUP BY.

peace95 · July 10th, 2009, 03:59 PM

Snufse:

Need more information:

The BOL (Bill of Laden), in the Receiving Dept, defines what is on the Packing Slip. In the Shipping Dept, the BOL defined shipment and included additional info besides the detailed items, the order number and the truck ID, because some orders may be on multiple trucks, which meant multiple BOL with same order number. Need to know Receiving or Shipping?
Need you to define your "LOAD" besides saying its the BOL, Full Truck Load, Partial Truck Load, etc. and what is "UDS"?
It would help to know the process for receiving, before giving a response.