Need help understanding the results of the Top
Should the output not be 4 records and not 3?
For ProductID 0f 716 and the order by making 7/1/15 at top there was a quanity ordered of 4 on one record
SELECT TOP (SELECT TOP 1 OrderQty
FROM [Sales].[SalesOrderDetail]
ORDER BY ModifiedDate) *
FROM [Sales].[SalesOrderDetail]
WHERE ProductID = 716;