title: Put Correct [Order] When inserting multiple ROWS?
body: <p>I have the following query,</p>
  
  <pre><code>INSERT INTO ProductsImages (BaseProductId, ImageId, [Order], CreatorId, CreationDateUtc, LastModifierId, LastModificationDateUtc)
  SELECT @BaseProductId, Id, ??, @UserId, GETUTCDATE(), @UserID, GETUTCDATE() FROM @ImageIDs;
  </code></pre>
  
  <p>I am inserting multiple records into <code>ProductsImages</code> table. But the problem is that I need to insert Order = 1 for the first row, Order = 2 for the second row and so on.</p>