From: isgdre@HotMail.com   
      
   Nice, Thanks for the info.   
      
   A couple of things though   
      
   row_number()'s help says it starts at 1.  I take it I would have to add   
   max(LineNumber) from the OrderDetails some how. I'd work on it but the   
   next ones a killer.   
      
   I unfortunately have no control over the SQL Server version.  This is an   
   add on to an existing application that supports SQL Server 2000 and 2005   
   and is currently working on 2008 compatibility.   
      
   So. the 2005 requirement is a problem.  Any other ideas?   
      
      
   Erland Sommarskog wrote:   
   > Guy Dreger (isgdre@HotMail.com) writes:   
   >> Hi, I have a table that contains order information,  each row contains   
   >> information about a detail item that's been order but the key is OrderID   
   >> and LineNumber.   
   >>   
   >> I'm trying to insert information into the table from another table but   
   >> other table does not have any type of line number information.  Also   
   >> there is now hard value for the number of rows already in the order   
   >> detail table.   
   >>   
   >> Is there a way to use “Insert into....” for this problem?  I.e   
   >>   
   >> Insert into OrderDetails od (OrderID, Item, Description, LineNumber)   
   >> select OrderID, '!NOTE!', Description, od.@ROWID() from OrderNotes   
   >   
   > If you are on SQL 2005 or later (hint! it is always a good idea to   
   > say which version of SQL Server you are using!), you can use the   
   > row_number function:   
   >   
   >    row_number() OVER (PARTITION BY OrderID ORDER BY somecolumn)   
   >   
   >   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)