Viewing post 1 (of 1 total)
Here we go:
SELECT
O.orderID
ROW_NUMBER() OVER(PARTITION BY O.orderID) AS line_item_no,
OL.productID
FROM Orders O
This can be used to set up line numbers...
December 6, 2013 at 12:55 pm
#1671641