weharrelson (1/11/2011)
Sorry for the delay guys:DECLARE @x XML
SELECT @x= CONVERT(xml, BulkColumn, 2) FROM
OPENROWSET(BULK 'C:\data.xml', SINGLE_BLOB) AS x
Ahh, I see. You loading the file in as I showed in the article, except that you're taking it straight to a variable. Then you're using that variable in sp_xml_preparedocument.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes