Primary key generating

Giganews Newsgroups
Subject: Primary key generating
Posted by:  mutemo‚Ķ
Date: 24 Aug 2006

Help again please,
I need to insert rows into a table from another table.  The tables are
identical column wise except the table im inserting from does not have
a primary key value.  On insert I need to generate a primary key that
is consecutive based on the table im inserting into. Also the table im
inserting into does not have a identity column.  Much appreciated.