You might want to look at BULK INSERT or BCP to import the file contents
into a table first, and then process the rows.
Vyas, MVP (SQL Server)
What hardware is your SQL Server running on?
"Ty" <tybala on the server at hotmail.com> wrote in message
I want to do something like this inside a sproc:
DECLARE internalText VARCHAR(8000)
Assuming the contents of myTestXML.XML is <=8000K, how do I pass the
contents of that file to the variable I declared?