SQL - insert row values from second column ( to new table as column data) -

while having result set:

name        values  product                         filler888 lot_number                  cg 00063 0 shift_supervisor        covaliu l kgh_all_set 90 kgh_all_real    133.183883666992 kgh_f1_set  90 kgh_f1_real 133.183883666992 k_f1    33 screw_rpm_set   400 screw_rpm_real  399.452606201172 torque  19.6692142486572 current 71.0029983520508 kw_kg   0.0553370267152786 kw  7.36999988555908 melt_pressure   0 melt_temperature    140 pv1 141 sp1 140 pv2 160 sp2 160 pv3 160 sp3 160 pv4 160 sp4 160 pv5 160 sp5 160 pv6 150 sp6 150 pv7 150 sp7 150 pv8 154 sp8 150 pv9 150 sp9 150 pv10    160 sp10    160 pv11    180 sp11    180 

i second table defined rows of 1st:

create table #zsk402temp  (  product varchar(25), lot_number varchar(25), shift_supervisor varchar(25),  kgh_all_set decimal,  kgh_all_real decimal,  kgh_f1_set decimal,  kgh_f1_real decimal,  k_f1 decimal,  screw_rpm_set decimal,  screw_rpm_real decimal,  torque decimal,  [current] decimal,  kw_kg  decimal,  kw decimal,  melt_pressure decimal,  melt_temperature decimal,  pv1 decimal,  sp1 decimal,  pv2 decimal,  sp2 decimal,  pv3 decimal,  sp3 decimal,  pv4 decimal,  sp4 decimal,  pv5 decimal,  sp5 decimal,  pv6 decimal,  sp6 decimal,  pv7 decimal,  sp7 decimal,  pv8 decimal,  sp8 decimal,  pv9 decimal,  sp9 decimal,  pv10 decimal,  sp10 decimal,  pv11 decimal,  sp11 decimal  ) 

to insert values 1st table column data in second table.

any kindly apreciated.

look examples using sql's pivot function. swap rows columns match new table.

link: http://technet.microsoft.com/en-us/library/ms177410(v=sql.105).aspx