duplicate rows

In Query:

SELECT Id + 100 As id, ParentId
From Table1

Select allOpen in new window

As a new Table:

Create Table Table2(Id(int), ParentId(int));
GO
Insert Table2(Id, ParentId) 
Select Id + 100 As id, ParentId From Table1;  

Select allOpen in new window

In the same table:

Update Table1 Set id = id +100;

Select allOpen in new window

Provided id is uneatable.

The Id is identity column, so I do not know the id number until after I have inserted the row.

johnson1,

Do you want:

a. In Query?
b. As a new Table? or
c. In the same table?

(see my first post)

It is not clear what you are asking for. Could you please explain a bit?

Mike

Hello,
I am doing this in a query. I already have a table with thousands of rows. I want to duplicate the rows, but each new row will get new Id because Id is an identity column. And the ParentId has to point to the new id.

 In the real table I have also a column that groups toghether the rows. I added below the column GroupId.

Id(int), ParentId(int), GroupId(int)
101, 0, 10
105, 101, 10
190, 101, 10
195, 190, 10
121, 0, 11
125, 121, 11
127, 121, 11
139, 127, 11

I would like to copy the rows that have certain GroupId. For example GroupId=10.
I want to insert the rows into the same table and create a new groupId.

Please let me know if this is not clear.