troubleshooting Question
SQL Query to Sum based on more then 1 col
asked on
Hello there,
I have this query which returns me the qty of each product in each office with their dates.now in the returned result i have repeated products with the same date in the same branch. i want to sum those records. how can i do it. I am using MSSQL 2008
I have this query which returns me the qty of each product in each office with their dates.now in the returned result i have repeated products with the same date in the same branch. i want to sum those records. how can i do it. I am using MSSQL 2008
SELECT
dbo.Branch.id,
dbo.Branch.name,
CONVERT(VARCHAR(10),dbo.Receipt.receiptDate,105) AS SaleDate,
dbo.Tafsil.description,
dbo.ProductBoughtSupplierDetail.quantity,
dbo.Batch.batchNumber
FROM
dbo.ProductBoughtSupplierDetail
INNER JOIN
dbo.ProductBoughtSupplier
ON
(
dbo.ProductBoughtSupplierDetail.productBoughtSupplierId = dbo.ProductBoughtSupplier.id)
INNER JOIN
dbo.Receipt
ON
(
dbo.ProductBoughtSupplier.warehouseReceiptId = dbo.Receipt.id)
INNER JOIN
dbo.Branch
ON
(
dbo.Receipt.targetBranchId = dbo.Branch.id)
INNER JOIN
dbo.Batch
ON
(
dbo.ProductBoughtSupplierDetail.batchId = dbo.Batch.id)
INNER JOIN
dbo.Tafsil
ON
(
dbo.Batch.productId = dbo.Tafsil.id)
WHERE
dbo.Receipt.receiptType = 5
AND dbo.ProductBoughtSupplier.invoiceReceiptId IS NULL ;
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.