creating a permanent table from the results of a select statement in sql server 2016
I have a SELECT statement that returns a result set, I now want to create a table from the results set.
SELECT INTO newtable
would work but it doesnt...
any help appreciated, thanks