SELECT
dbo.Receipt.transactionNumber,
dbo.Receipt.receiptDate,
dbo.Tafsil.description,
dbo.Branch.name,
SUM(dbo.SaleDetail.quantity) AS SalesQtyinclDis,
dbo.DeliveryOrderDetail.quantity AS SalesQty,
dbo.DeliveryOrderDetail.quantityDiscount AS Dis1,
dbo.DeliveryOrderDetail.supplierQuantityDiscount AS Dis2
FROM
dbo.SaleDetail
INNER JOIN
dbo.Sale
ON
(
dbo.SaleDetail.saleId = dbo.Sale.id)
INNER JOIN
dbo.Receipt
ON
(
dbo.Sale.invoiceReceiptId = dbo.Receipt.id)
INNER JOIN
dbo.Batch Batch_alias1
ON
(
dbo.SaleDetail.batchId = Batch_alias1.id)
INNER JOIN
dbo.Tafsil
ON
(
Batch_alias1.productId = dbo.Tafsil.id)
INNER JOIN
dbo.Branch
ON
(
dbo.Receipt.branchId = dbo.Branch.id)
INNER JOIN
dbo.DeliveryOrderDetail
ON
(
dbo.SaleDetail.orderDetailId = dbo.DeliveryOrderDetail.id)
INNER JOIN
dbo.Mohin
ON
(
dbo.Tafsil.mohinId = dbo.Mohin.id)
INNER JOIN
dbo.Kol
ON
(
dbo.Mohin.kolId = dbo.Kol.id)
WHERE
dbo.Receipt.receiptDate >= '2015-06-22'
AND dbo.Receipt.receiptDate < '2015-07-23'
GROUP BY
dbo.Receipt.transactionNumber,
dbo.Receipt.receiptDate,
dbo.Tafsil.description,
dbo.Branch.name,
dbo.DeliveryOrderDetail.quantity,
dbo.DeliveryOrderDetail.quantityDiscount,
dbo.DeliveryOrderDetail.supplierQuantityDiscount ;
SELECT
--dbo.Receipt.transactionNumber,
--dbo.Receipt.receiptDate,
dbo.Tafsil.description as ProductName,
dbo.Branch.name as BranchOffice,
SUM(dbo.SaleDetail.quantity) AS SalesQtyInclDis,
--dbo.DeliveryOrderDetail.quantity AS SalesQty,
--dbo.DeliveryOrderDetail.quantityDiscount AS Dis1,
--dbo.DeliveryOrderDetail.supplierQuantityDiscount AS Dis2,
SUM(DeliveryOrderDetail.quantityDiscount+DeliveryOrderDetail.supplierQuantityDiscount) as TotalDiscount
FROM
dbo.SaleDetail
INNER JOIN
dbo.Sale
ON
(
dbo.SaleDetail.saleId = dbo.Sale.id)
INNER JOIN
dbo.Receipt
ON
(
dbo.Sale.invoiceReceiptId = dbo.Receipt.id)
INNER JOIN
dbo.Batch Batch_alias1
ON
(
dbo.SaleDetail.batchId = Batch_alias1.id)
INNER JOIN
dbo.Tafsil
ON
(
Batch_alias1.productId = dbo.Tafsil.id)
INNER JOIN
dbo.Branch
ON
(
dbo.Receipt.branchId = dbo.Branch.id)
INNER JOIN
dbo.DeliveryOrderDetail
ON
(
dbo.SaleDetail.orderDetailId = dbo.DeliveryOrderDetail.id)
INNER JOIN
dbo.Mohin
ON
(
dbo.Tafsil.mohinId = dbo.Mohin.id)
INNER JOIN
dbo.Kol
ON
(
dbo.Mohin.kolId = dbo.Kol.id)
WHERE
dbo.Receipt.receiptDate >= '2015-06-22'
AND dbo.Receipt.receiptDate < '2015-07-23'
GROUP BY
--dbo.Receipt.transactionNumber,
--dbo.Receipt.receiptDate,
dbo.Tafsil.description,
dbo.Branch.name
--dbo.DeliveryOrderDetail.quantity,
--dbo.DeliveryOrderDetail.quantityDiscount,
--dbo.DeliveryOrderDetail.supplierQuantityDiscount ;
SELECT
dbo.Receipt.transactionNumber,
dbo.Receipt.receiptDate,
dbo.Tafsil.description as productName,
dbo.Branch.name as branchoffice,
SUM(dbo.SaleDetail.quantity) AS SalesQtyinclDis,
dbo.DeliveryOrderDetail.quantity AS SalesQty,
dbo.DeliveryOrderDetail.quantityDiscount AS Dis1,
dbo.DeliveryOrderDetail.supplierQuantityDiscount AS Dis2,
(dbo.DeliveryOrderDetail.quantityDiscount+dbo.DeliveryOrderDetail.supplierQuantityDiscount) as DiscountSum
FROM
dbo.SaleDetail
INNER JOIN
dbo.Sale
ON
(
dbo.SaleDetail.saleId = dbo.Sale.id)
INNER JOIN
dbo.Receipt
ON
(
dbo.Sale.invoiceReceiptId = dbo.Receipt.id)
INNER JOIN
dbo.Batch Batch_alias1
ON
(
dbo.SaleDetail.batchId = Batch_alias1.id)
INNER JOIN
dbo.Tafsil
ON
(
Batch_alias1.productId = dbo.Tafsil.id)
INNER JOIN
dbo.Branch
ON
(
dbo.Receipt.branchId = dbo.Branch.id)
INNER JOIN
dbo.DeliveryOrderDetail
ON
(
dbo.SaleDetail.orderDetailId = dbo.DeliveryOrderDetail.id)
INNER JOIN
dbo.Mohin
ON
(
dbo.Tafsil.mohinId = dbo.Mohin.id)
INNER JOIN
dbo.Kol
ON
(
dbo.Mohin.kolId = dbo.Kol.id)
WHERE
dbo.Receipt.receiptDate >= '2015-06-22'
AND dbo.Receipt.receiptDate < '2015-07-23'
GROUP BY
dbo.Receipt.transactionNumber,
dbo.Receipt.receiptDate,
dbo.Tafsil.description,
dbo.Branch.name,
dbo.DeliveryOrderDetail.quantity,
dbo.DeliveryOrderDetail.quantityDiscount,
dbo.DeliveryOrderDetail.supplierQuantityDiscount ;
Open in new window
?