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
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.
answered Feb 23 '12 at 02:46 PM
Grant Fritchey ♦♦