Everyone knows that a table can be created using a subquery in oracle. How to do the same task in SQL Server.
In Oracle I tried as "create table table1 as select * from table2"
My requirement is to create dynamic tables in stored procedure based on existing tables.
I'm so desperate, I need help from IT kings like you.