SQL Query Flattens Order and Top Order Items

SQL Query Flattens Order and Top Order Items

I need help building a SQL query that returns a flattened result of the
top 2 items in an order.
The tables and relevant fields are as follows:
Order OrderItem
------- -----------
orderId orderId
productCode
quantity
I'm looking for the desired result set:
[orderId] [productCode1] [quantity1] [productCode2] [quantity2]
---------- -------------- ----------- -------------- -----------
o123 p134 3 p947 1
o456 p384 2 p576 1
The results would be grouped by orderId from Order, with the TOP 2
productCode from quantity from OrderItem. I don't care which TOP 2 get
returned, just need any two.
Any help would be greatly appreciated.