Hi All I have multiple rows to insert in the same table all the data is the same except for the Pk field this needs to be incremented by one as this is then needed to be inserted into another table along with an additional feild. In this instance there is a fixed number of rows that I can retrive using a select statement. thanks in advance for any helpreagrds Mratin
asked Feb 23 '12 at 02:13 PM in Default
I'm not completely sure what you're going for here, but have you looked at the ROW_NUMBER function? That will give you the ability to SELECT data and simultaneously create numbers.
Or, do you need to create an IDENTITY column in your table? That increments automatically as you insert data. If you use the [OUTPUT] clause you can capture all the values as they get created.: http://msdn.microsoft.com/en-us/library/ms177564.aspx
answered Feb 23 '12 at 02:46 PM
Grant Fritchey ♦♦