Anyone know how to return groups of a particular number.
I want it to work like TOP 3 but within groups.
For example I want to generate a cursor that lists all orders but only the first 3 or so line items.

Assuming that all orders have more than 3 items and I want to see the the first 3 of each; I would want to show the following and pitch anything else.

OrderId1
Item1
Item2
ITem3
OrderId2
Item1
Item2
ITem3

Thanks,
Chris