--***Запрос***
SET NOCOUNT ON;
if object_id('tempdb..#t','U') is not null drop table #t
create table #t (dir nvarchar(255))
declare @dir nvarchar(255)='\\S1\users'
insert into #t exec xp_subdirs @dir
SELECT row_number() over(order by dir) as no, dir , @dir+dir path from #t
drop table #t

SELECT * INTO [Запрос] FROM (***Запрос***) t

 
insert into t (path)
select @dir+dir path
from #t

insert into #t exec xp_subdirs @dir

--Запрос
SET NOCOUNT ON;
if object_id('tempdb..#t','U') is not null drop table #t
create table #t (dir nvarchar(255))
declare @dir nvarchar(255)='\\S1\users'
insert into #t exec xp_subdirs @dir
SELECT row_number() over(order by dir) as no, dir , @dir+dir path from #t
drop table #t

SELECT * INTO TableNew FROM (Запрос) t

SELECT t.* INTO #TableNew FROM (Запрос) t

insert into #t 

SELECT t.* INTO НоваяТаблицаБД FROM (Запрос) t

SELECT t.* INTO НоваяТаблицаБД FROM (Select * from _Users) t

SELECT t.* INTO [НоваяТаблицаБД] FROM (select * from #t) t

select @Query = replace (@QUEY, 'from #t', 'into Table_name from #t')

--Запрос
SET NOCOUNT ON;
if object_id('tempdb..#t','U') is not null drop table #t
create table #t (dir nvarchar(255))
declare @dir nvarchar(255)='\\S1\users'
insert into #t exec xp_subdirs @dir
SELECT row_number() over(order by dir) as no, dir , @dir+dir path from #t
drop table #t

DECLARE  @sql NVARCHAR(MAX) =
'DECLARE @i INT;
SELECT @i = 10;
SELECT @i = @i*2;
SELECT *
    FROM [sys].[objects] [o]
    WHERE [o].[object_id] <= @i;';
EXEC ('SET FMTONLY ON;' + @sql);
EXEC (@sql);