Creating A Table With A Dual Primary Key

This question may be a little complicated.





I am building a DTS Package that is moving data from our webstore (written in house) to a Warehouse Management System(WMS - Turnkey) and I've encountered a problem. both pieces of software have an orders table and an Ordered_Items table, related by the order_ID (makes sense so far). Here is the problem. The primary key on the webstore's Ordered_Items table is a single column (basically an Identity variable), while the primary key on the WMS's Ordered_Items table is a dual column primary key, between the Order_ID and the Order_LineID, so the data should be stored like:





OrderID Order_LineID


1 1


2 1


2 2


2 3


3 1


3 2


4 1





Get the Idea? So I have to create this new Order_LineID column. How can I accomplish this with a SQL statement?





Thanks!!!!!