Home Forums SQL Server 7,2000 General Dynamic SQL for variable TableName with OpenXML RE: Dynamic SQL for variable TableName with OpenXML
Tim ffitch
SSCommitted
Points: 1637
More actions
February 11, 2008 at 10:25 am
#776989
Has the XML you are trying to work with got a namespace defined? If it has you have to set up the namespace in the sp_xml_preparedocument arguments.
My first and only foray into XML taught me this after much hair extraction!
Tim