Copying data from one table to another

[sndkick]

I have a table containing multiple fields and i need to copy all data from 2 of the fields into another table that i just created. What's the best way to do this?

Any help would be much appreciated. Scott

 

[sndkick]

NEVERMIND... this was simple, i figured it out.

INSERT INTO dbo.tablename (val1, val2)
SELECT oldVAl1, oldVAl2
FROM oldTable
Scott