Home Forums SQL Server 2008 T-SQL (SS2K8) Need help on SQL script RE: Need help on SQL script
jds-685721
SSC Enthusiast
Points: 128
More actions
February 6, 2014 at 1:59 pm
#1686768
Oh it’s just for me as a learner 😉
What I did is follow Keith’s instruction like below:
insert TBL1
select 3, Col2, Col6, Col4, Col5, Col6 -- replace Col3 with Col6
from TBL1
where Col1 = 1