>
Should this SP return multiple result sets or one result (top Y of products)?
>
>Also, how the order date comes into play? >
>
>Just 1 result set......
>
>The queries should retrieve orders where the order date (In PurchaseOrderHeader) falls between the two date parameters (for begindate/enddate)
One more question - is Purchasing.PurchaseOrderDetail connected with Production.Product (e.g. where the product names are coming from)?
If it's not broken, fix it until it is.
My Blog