create table Roland1
PK_1 int identity (1, 1) primary key,
create table Roland2 (PK_2 int identity (1, 1) primary key)
create table Roland3 (PK_2 int, seq int, c int)
insert into Roland1 values (1, 2, 3, 5, 8, 13, 21, 34, 55, 89)
insert into Roland1 values (1, 2, 3, 5, 7, 11, 13, 17, 19, 23)
set identity_insert Roland2 on
insert into Roland2 (PK_2)
select PK_1 from Roland1
set identity_insert Roland2 off
' from Roland1 '
select * from Roland2
select * from Roland3
> I got one big unnormalized table with a group of columns repeating 10
> times. So the column names contain numbers from 1 to 10. Now I want to
> get a normalized table from this.
> Has anyone experience doing this with a reasonable performance? I'd
> probably prefer a solution written in pure TSQL.
> Thanks in advance,