One is to use an INSERT INTO which can be used where the table is already created

INSERT INTO TestTable (FirstName, LastName)
SELECT FirstName, LastName
FROM Person.Contact
WHERE EmailPromotion = 2

The second is to use a SELECT INTO which can be used to also auto create the table

SELECT FirstName, LastName
INTO TestTable
FROM Person.Contact
WHERE EmailPromotion = 2

Thanks to pinaldave for this tips - the fuller explaination can be found at http://blog.sqlauthority.com/2007/08/15/sql-server-insert-data-from-one-table-to-another-table-insert-into-select-select-into-table/