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