Insert multiple rows against a single primary key

@Jayesh, if you plan to copy others answers and post it as yours, at least make sure you rectify the spelling mistakes done in original post.

  just happen to observer that you got UnitPrice column of data type Money in one table and Integer in another

First, you cannot do that.

 

Second, why would you do that. Got any solid business explaination. A situation which is forcing you to do that.

 

For example, if there are two product ids in one order, I would just total their quantities, isn't it?

 

Please elaborate.

 

Also, just happen to observer that you got UnitPrice column of data type Money in one table and Integer in another. Doesn't look right to me.