does this get anywhere close...??

;

WITH cte

AS (

SELECT SalesOrderNumber,

ItemNumber,

QuantityOrdered,

MIN(VersionNumber) AS VerMin,

MAX(VersionNumber) AS VerMax

FROM Orders

GROUP BY SalesOrderNumber,

ItemNumber,

QuantityOrdered

)

SELECT cte.SalesOrderNumber,

cte.ItemNumber,

OMin.OrderDate,

OMin.RequestedDeliveryDate,

OMin.PromisedDeliveryDate,

OMin.QuantityOrdered,

OMax.PostingDate,

OMax.QuantityShipped

FROM Orders AS OMin

INNER JOIN cte ON OMin.SalesOrderNumber = cte.SalesOrderNumber

AND OMin.VersionNumber = cte.VerMin

AND OMin.ItemNumber = cte.ItemNumber

INNER JOIN Orders AS OMax ON cte.SalesOrderNumber = OMax.SalesOrderNumber

AND cte.VerMax = OMax.VersionNumber

AND cte.ItemNumber = OMax.ItemNumber

edit...tidied up the formatting :hehe: