SQl: Select into
SELECT FirstName, LastName INTO TestTable FROM Person.Contact WHERE EmailPromotion = 2