if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_ArrayString2Table2]') and OBJECTPROPERTY(id, N'IsProcedure') =  1 )
drop procedure [dbo].[sp_ArrayString2Table2]
GO


CREATE PROCEDURE [dbo].[sp_ArrayString2Table2]
	@instr text=NULL, @rowpattern varchar( 100 ) = '//node'
AS

IF @instr IS NULL
	RETURN - 1 

DECLARE @XMLHandler int

EXEC sp_xml_preparedocument @XMLHandler OUTPUT, @instr  
SELECT * FROM OpenXML(@XMLHandler, @rowpattern,  0 ) WITH (value int '@value')
EXEC sp_xml_removedocument @XMLHandler


go

create table #t(value int)
insert #t exec [dbo].[sp_ArrayString2Table2] '<root><node value="1"></node><node value="2"></node>
<node value="3"></node><node value="4"></node></root>'
select * from #t
drop table #t
go

Public cnn, cmd, rst, strConn, fso, file, fh
Set cnn	= CreateObject( "ADODB.Connection" )
Set cmd	= CreateObject( "ADODB.Command" )
Set rst	= CreateObject( "ADODB.Recordset" )
Set fso	= CreateObject( "Scripting.FileSystemObject" )
Set file = fso.GetFile( "c:\myxml9.xml" )
Set fh = file.OpenAstextStream( 1 , - 1 )

strConn =  "PROVIDER=MSDASQL;DRIVER={SQL Server};"  & _
	 "SERVER=myserver;"  & _
	 "DATABASE=pubs;"  & _
	 "Trusted_connection=Yes;"  & _
	 "Network=DBMSSOCN;"  & _
	 "UseProcForPrepare=0 ;" & _
	 "AutoTranslate=No" 

With cnn
        .ConnectionString = strConn
        .Open strConn
	.CommandTimeout =  0 
End With

If cnn.State =  1  Then
	WScript.Echo  "Connected" 
	Set cmd.ActiveConnection = cnn
	cmd.CommandText =  "sp_ArrayString2Table2" 
	cmd.CommandType =  4 
	cmd.CommandTimeout =  0 

            
	' Set up an input parameter.
	x = fh.ReadAll()
	cmd.Parameters.Append cmd.CreateParameter( "Input" ,  201 ,  1 , Len(x), x)

	start = Now
	Set rst = cmd.Execute
	WScript.Echo datediff( "s" , start, Now())
	rst.Close
End If
cnn.Close
Set cnn = Nothing
Set cmd = Nothing
Set fso = Nothing
Set file = Nothing
Set fn = Nothing

Кол-во записей    Время, сек
 50   000                 3 
 100   000                5 
 200   000                10 
 300   000                16 
 500   000                34 
 900   000                88