Look at using Select ... INTO
Example:
Select *
INTO MyNewTable
from MyOldTable
Uses whatever it derives from the query to make a table.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?