Author: Not specified Language: tsql
Description: Not specified Timestamp: 2017-06-15 13:30:22 +0000
View raw paste Reply

SELECT DISTINCT cntnr_name, SUM(((quantity*uom_weight)*.0022)) AS 'Total Weight' FROM v_inventory
WHERE cntnr_name in ('12 400290','12 400942','12 400841','12 400733','12 400189','12 401174',
                '12 400794','12 401495','12 401004','12 200667','12 201347','12 200765','12 401485','12 200004','12 201331')
GROUP BY cntnr_name
View raw paste Reply