Keith Tate (2/3/2014)

---

Welcome to the forum and congrats on trying to improve you T-SQL coding ability. Please read the article in my signature and repost you question with the create table statements and sample data inserts along with the desired output. This will help you get a more precise answer.

With that being said you could do the following:

insert TBL1

select 3, Col2, Col3, Col4, Col5

from TBL1

where Col1 = 1