Select into?? 1

[Laeg]

tblA

col1| col2| col3
1 A B

want to take the values associated with value 1
and insert a new record with my own hardcoded
value for col1.

So will end up with
col1| col2| col3
1 A B
12 A B
27 A B

Do I need a cursor or what is the easiest way to do this?

 

[swampBoogie]

insert into t
select 12,col2,col3 
from t
where col1 = 1