testtext --------------= Posted using GrabIt =---------------- ------= Binary Usenet downloading made easy =--------- -= Get GrabIt for free from http://www.shemes.com/ =-

...> EXEC sp_xml_preparedocument @idoc OUTPUT select * from testtext where id=3 for xml auto ... @idoc as int AS insert into testtext (test) select test from openxml(@idoc,'/testtext',0) WITH (id int, test text) GO My Idea was to ...) Select <WhatEverXMLColumnNameYouWant> From <DBName>.<ObjectOwner>.testtext where id=3- Hide quoted text - ...

...> EXEC sp_xml_preparedocument @idoc OUTPUT select * from testtext where id=3 for xml auto ...> @idoc as int AS insert into testtext (test) select test from openxml(@idoc,'/testtext',0) WITH (id int, test text) GO My Idea was to ...Insert INTO #t (MyXMLColumn) Select <WhatEverXMLColumnNameYouWant> From <DBName>.<ObjectOwner>.testtext where id=3

... and parse the XML document in Memory EXEC sp_xml_preparedocument @idoc OUTPUT select * from testtext where id=3 for xml auto exec testXMLInsert @idoc --now clear ... CREATE PROCEDURE [dbo].[testXMLInsert] @idoc as int AS insert into testtext (test) select test from openxml(@idoc,'/testtext',0) WITH (id int, test text) GO My Idea was to parse the handle to the XML ...

...Load and parse the XML document in Memory EXEC sp_xml_preparedocument @idoc OUTPUT select * from testtext where id=3 for xml auto exec testXMLInsert @idoc --now clear the XML ... SP 2 CREATE PROCEDURE [dbo].[testXMLInsert] @idoc as int AS insert into testtext (test) select test from openxml(@idoc,'/testtext',0) WITH (id int, test text) GO My Idea was to parse the handle to the XML ...