From: drscrypt@gmail.com   
      
   Erland Sommarskog wrote:   
   > Say that you need to insert a number of rows in a table, with each   
   > row being assigned a unique, sequential, id, the typical construct is:   
   > ...   
      
      
   > Whether that fits in the context you are working, I don't know.   
   > Furthermore, this solution requires SQL 2005 or higher.   
   >   
      
      
   Unfortunately not.  I use this technique elsewhere but what I need is   
   the ability to generate such numbers one at a time.  And sometimes, I   
   need 2 or 3 of these at a time, depending on the results of the formulas   
   I use in the package.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)