You are creating a number of tables for your product database. You want to create a table based on the properties of the columns and the data contained in rows output by a particular query and new table must be automatically populated with the data that is generated by the query.

Which T-SQL statements would you use for this task ?