Steve and Chris,

Thank you so much for the food for thought.  While I was trapped in the thought process of requiring a line number, I lost site of the possible...

Sergey,

Thank you for your reply.  However, what we need, it a line number for each record within the order.  What you have provided here just gives me the number of...

Thank you, Lynn.  I did consider using a concatenated key of OrderId and LineNumber, but at the last minute changed my mind.  Mostly because I was trying to follow the...

Thanks Greg.  I did consider staging tables, but that would require a lot of tables.  I wasn't sure I wanted to create so many.  I'll definitely think more on it. ...