1 2 3 4 5 6 7 8 9 10 11 12
| SELECT sr.SalesReturnId, sr.ReturnDate, sr.InvoiceNo,
CONCAT(s.lastname, ', ', s.firstname, ' ', s.MI) as StaffName,
sr.TotalAmount, SUM(sri.Quantity) as TotalQuantity
FROM SalesReturn sr
INNER JOIN SalesReturnItem sri
ON sr.InvoiceNo = sri.InvoiceNo
INNER JOIN Staff s
ON s.StaffId = sr.userID
WHERE ReturnDate BETWEEN CONVERT(datetime2,'18/01/1000',103) AND CONVERT(datetime2,'19/06/2050',103)
AND sr.InvoiceNo LIKE '%%'
GROUP BY sr.SalesReturnId, sr.ReturnDate, sr.InvoiceNo, sr.TotalAmount, s.lastname, s.firstname, s.MI
ORDER BY ReturnDate, sr.InvoiceNo DESC |
Partager