use master
go

exec sp_addlinkedserver N'127.0.0.1'
                      , N'SQL Server';

...
	IF OBJECT_ID ('tempdb.dbo.#su5_data') IS NOT NULL DROP TABLE #su5_data
	CREATE TABLE #su5_data(
		[LINK] [int] NOT NULL,
		[C_Alt_Number] [varchar](100) NULL,
		[F_Sale_Categories] [tinyint] NULL,
		[ssd_name] [varchar](250) NULL,
		[sd_name] [varchar](150) NULL,
		[ss_name] [varchar](150) NULL,
		[C_Network_Path] [varchar](1000) NULL,
		[C_Number] [varchar](306) NULL,
		[D_Date] [smalldatetime] NULL,
		[C_FIO] [nvarchar](max) NOT NULL,
		[C_Name1] [nvarchar](max) NULL,
		[C_Person] [varchar](2) NOT NULL,
		[C_Address1] [varchar](350) NULL,
		[N_Quantity] [decimal](18, 4) NULL,
		[N_Amount] [money] NULL,
		[N_Amount_Pay] [money] NULL,
		[N_Quantity_Pay] [decimal](19, 6) NULL,
		[N_Debt] [money] NULL,
		[ell_Name] [varchar](50) NULL,
		[d_date_sud] [smalldatetime] NULL,
		[D_Done_Date] [smalldatetime] NULL,
		[C_Reason_Types] [varchar](20) NULL,
		[C_Judgement_Decision] [varchar](255) NULL,
		[D_Last_Pay] [smalldatetime] NULL,
		[C_Notes] [varchar](4000) NULL,
		[C_Status] [varchar](50) NULL
	) 

	INSERT INTO #su5_data(
	[LINK]
      ,[C_Alt_Number]
      ,[F_Sale_Categories]
      ,[ssd_name]
      ,[sd_name]
      ,[ss_name]
      ,[C_Network_Path]
      ,[C_Number]
      ,[D_Date]
      ,[C_FIO]
      ,[C_Name1]
      ,[C_Person]
      ,[C_Address1]
      ,[N_Quantity]
      ,[N_Amount]
      ,[N_Amount_Pay]
      ,[N_Quantity_Pay]
      ,[N_Debt]
      ,[ell_Name]
      ,[d_date_sud]
      ,[D_Done_Date]
      ,[C_Reason_Types]
      ,[C_Judgement_Decision]
      ,[D_Last_Pay]
      ,[C_Notes]
      ,[C_Status]
	)
	select * from OpenQuery ( [127.0.0.1], 'EXEC EE.RPT_107_Statements_NoSubscr @N_Date_Mode = 0, @D_Date0 = ' + @begin_date +	', @D_Date = ' + @end_date + ', @C_SubDivisions = ' + @C_Divs +	', @F_Network_Items = NULL, @F_Partner_Types = NULL, @F_Networks = ' + @C_Networks )
...