quote:

---

Originally posted by speedy_gonzalos

Hi,

Im just wondering why i havent received any replies as yet? is it because you dont understand what im asking or is it something else?
its just that i would appreciate any hints or tips as soon as possible.

Thanks
Shabana

---

SELECT DISTINCT [Orders].[ShippingEnteredDate]
, [Orders].[DealerID]
, [Orders].[OrderID]
, [Orders].[OrderDate]
, [Orders].[PurchaseOrderNumber]
, [Orders].[CustomerRef]
, [Orders].[ShipName]
, [Orders].[ShipDate]
, [Orders].[TrackingNumber]
, [Orders].[MethodofPayment]
, [Orders].[Amount]
, [Orders].[CurrencyType]
, [Orders].[EnquiryID]
, [OrderDetails].[SerialNumber]
, [Orders].[SaleType]
, [Orders].[OrderDespatchedFrom] AS DespatchedFrom
, CASE WHEN od1.SerialNumber IS NULL THEN 0 ELSE 1 END AS MinLine
FROM Orders 
INNER JOIN OrderDetails 
ON [Orders].[OrderID]=[OrderDetails].[OrderID]
LEFT JOIN (SELECT OrderID,MIN(SerialNumber) AS MinDetail
           FROM OrderDetails
           GROUP BY OrderID)od1
ON od1.[OrderID]=[OrderDetails].[OrderID]
AND od1.MinDetail=[OrderDetails].SerialNumber
WHERE ((([Orders].[ShippingEnteredDate]) Between @startdate And @enddate) And (([Orders].[Cancelled])<>1))
ORDER BY [Orders].[OrderID], [Orders].[OrderDate] DESC;

then for getting correct total group by SaleType and take sum as

SUM(CASE WHEN MinDetail=1 THEN Amount ELSE 0 END) AS Total

quote:

---

Originally posted by tosscrosby

And also, many of us have jobs (this is a free site, unless Visakh is getting paid???) and cannot always get to the posts as quickly as the posters may like. But we do come along at some point.

Terry

-- Procrastinate now!

---

quote:

---

Originally posted by speedy_gonzalos

Thanks for the reply, Visakh, i will defo try that.
And Terry, i only asked the question as i was curious why i hadnt got a reply, because other people who had posted after me had more interaction (replies). Since i am fairly new to this, i thought id done something wrong. But as Visakh replied, it was because i posted it in the wrong forum. I understand poeple have jobs, including me, and i was not insinuating anything at all so no need to get harsh so quickly...take a chill pill, :)

Until the next time...laters
And thanks for your assistance!

---