Home All Groups Group Topic Archive Search About

SQL Server XML

microsoft.public.sqlserver.xml
Score How to Walk an XML Hierarchy Backwards
Rob - 7 Nov 2007 7:30 PM - 7 messages
To all, I have a process in which I need to walk an XML hierarchy backwards (I think) because I need to apply rules on the data that impact its parents data and therefore its subsequent rules.  Which in turn impact ...
Score select for xml to msxml2.domdocument
TOUDIdel - 6 Nov 2007 11:35 AM - 6 messages
How can I put result of my sql procedure (which ends returning select ... for xml auto) into msxml2.domdocument object (i.e. in JScript) ...
Score XML Hierarchy Query
Rob - 5 Nov 2007 11:14 PM - 4 messages
To all, I need help in "flattening" an XML Hierarchy to be used in a downstream process.  I am using SQL 2005. Take this XML: <Active>     <SummaryGroup>         <GroupID>Income</GroupID> ...
Score How to read values from a table after inserting xml using OPENROWSET
dhv919401 - 5 Nov 2007 5:40 PM - 3 messages
I have a multiple security files generated from Great Plains for different security classes. I will generate those files from the application and copy them to a folder. Now I need to shred the values from those xml files and load them in a ...
Score IIS SQL 2000 HTTP XML Query "Page Cannot be displayed"
Mike P - 4 Nov 2007 5:13 AM - 1 message
Hi, I have a 2003 server with sp2 with SQL 2000 sp4 tools installed.  I setup a virtual directory\template to a sql 2000 server and I receive a page cannot be displayed.  I ran filemon and see that when I go to the http link it calls ...
Next »