select *
into newtable
from
(select id,'a' as abc, a as rate from oldtable order by id
union
select id,'b' as abc, b from oldtable
union
select id,'c' as abc, c from oldtable
union
...
) T
into newtable
from
(select id,'a' as abc, a as rate from oldtable order by id
union
select id,'b' as abc, b from oldtable
union
select id,'c' as abc, c from oldtable
union
...
) T
from
(select id,'a' as abc, a as rate from oldtable order by id
union
select id,'b' as abc, b from oldtable
union
select id,'c' as abc, c from oldtable
union
...
) T
order by id,abc
from
(select id,'a' as abc, a as rate from oldtable
union
select id,'b' as abc, b as rate from oldtable
union
select id,'c' as abc, c as rate from oldtable
union
...
) T order by id,rate