InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 07:59:23 GMT20http://www.sqlservercentral.com/Forums/Topic1394448-392-1.aspxAny One Please Help me...pls take it as challenges...Regards,Saravanan.DTue, 11 Dec 2012 22:06:59 GMTsarwaanmcahttp://www.sqlservercentral.com/Forums/Topic1394448-392-1.aspxAny One Please Help me...Regards,Saravanan.DMon, 10 Dec 2012 22:23:07 GMTsarwaanmcahttp://www.sqlservercentral.com/Forums/Topic1394448-392-1.aspxHi,I Successfully Imported the Following XML File ...-------------------------------------------------------------------------------------[code="sql"] DECLARE @idoc intDECLARE @doc xmlDECLARE @xmldata Table (FirstName varchar(110), LastName varchar(210), Email varchar(110), Phone varchar(110), Position varchar(110), Branch varchar(110), Address varchar(110))SET @doc ='<Root> <Node FirstName="Andrew" LastName="Fuller" Email="afuller@contoso.com" Phone="(205) 555 - 9898" Position="CEO" Branch="TopManagement" Address="London, 120 Hanover Sq."> <Node FirstName="Jeremy" LastName="Boather" Email="jboather@contoso.com" Phone="(205) 555 - 9888" Position="President QA" Branch="QA" Address="London, 120 Hanover Sq."> <Node FirstName="Anne" LastName="Dodsworth" Email="adodsworth@contoso.com" Phone="(205) 555 - 9887" Position="VP QA" Branch="QA" Address="London, 120 Hanover Sq."> <Node FirstName="Alexander" LastName="Tuckings" Email="atuckings@contoso.com" Phone="(205) 555 - 9886" Position="Team Lead Team1" Branch="QA" Address="London, 120 Hanover Sq."> <Node FirstName="Brenda" LastName="Smith" Email="bsmith@contoso.com" Phone="(205) 555 - 9885" Position="Senior QA" Branch="QA" Address="London, 120 Hanover Sq."/> </Node> <Node FirstName="Mary" LastName="Bird" Email="mbird@contoso.com" Phone="(205) 555 - 9885" Position="Team Lead Team2" Branch="QA" Address="London, 120 Hanover Sq."/> </Node> </Node> <Node FirstName="Steven" LastName="Buchanan" Email="sbuchanan@contoso.com" Phone="(205) 555 - 9897" Position="President Dev Dept." Branch="Development" Address="London, 120 Hanover Sq."> <Node FirstName="Robert" LastName="King" Email="rking@contoso.com" Phone="(205) 555 - 9896" Position="VP Dev Dept." Branch="Development" Address="London, 120 Hanover Sq."> <Node FirstName="Laura" LastName="Callahan" Email="lcallahan@contoso.com" Phone="(205) 555 - 9892" Position="Team Lead Team1" Branch="Development" Address="London, 120 Hanover Sq."> <Node FirstName="Jason" LastName="Roland" Email="jroland@contoso.com" Phone="(205) 555 - 9872" Position="Senior Dev" Branch="Development" Address="London, 120 Hanover Sq."> </Node> </Node> <Node FirstName="Eric" LastName="Danstin" Email="edanstin@contoso.com" Phone="(205) 555 - 9882" Position="Team Lead Team2" Branch="Development" Address="London, 120 Hanover Sq."> <Node FirstName="Elizabeth" LastName="Lincoln" Email="elincoln@contoso.com" Phone="(205) 555 - 9862" Position="Senior Dev" Branch="Development" Address="London, 120 Hanover Sq."> </Node> <Node FirstName="Margaret" LastName="Peacock" Email="mpeacock@contoso.com" Phone="(205) 555 - 9852" Position="Senior Dev" Branch="Development" Address="London, 120 Hanover Sq."> </Node> </Node> </Node> </Node> </Node></Root>'EXEC sp_xml_preparedocument @idoc OUTPUT, @docInsert @xmldataSELECT *FROM OPENXML (@idoc,'//Node',1) WITH (FirstName varchar(110), LastName varchar(210), Email varchar(110), Phone varchar(110), Position varchar(110), Branch varchar(110), Address varchar(110)) select * from @xmldata [/code] ---------------------------------------------------------------------------------------------------------Again I Want to Export the Same XML File ...Using The Output Data (Table Value )....How To Export XML File...pls Any one Help me....Regards, Saravanan.K.DSun, 09 Dec 2012 22:34:56 GMTsarwaanmca