|
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 help reagrds Mratin
(comments are locked)
|
|
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. I need to insert 88 rows all have the same information as thery are concessionsn and each task needs a seperate concession the PK is the identifer for the table that joins the concession iformation and task information so I am thinking along thje lines of : Insert into Table A, (col b, col c, Col d .... Col N) Values (a, b, c, d.....z) With a loop or counter of some sort to use the PK and increment by 1 each time into Col A Regards Martin
Feb 23 '12 at 02:57 PM
Souchie
OK, then you should modify TableA to use an IDENTITY column. It will do that work for you.
Feb 23 '12 at 02:59 PM
Grant Fritchey ♦♦
(comments are locked)
|
