Subject:Changing name value pairs to table structure in xml Author:s g Date:23 Feb 2008 04:45 PM Originally Posted: 23 Feb 2008 04:43 PM
I have an XML dumped out of a webservice call. Basically it just returns a bunch of name value pairs. Based on the Field Names i know which pairs are elements of which table ... but i am not able to figure out if it is possible in XQUERY/XPATH - ultimately i need to produce a report from this information. I hope the Example makes a little more sense. I am a newbie so any help would be greatly appriciated. I hope i have clearly explained the structure...
Basically
Main# is the TableName,
Sub# is the Row denominator
ColName# is the columns and values in the rows...
Subject:Changing name value pairs to table structure in xml Author:s g Date:24 Feb 2008 05:43 PM
i am a newbie - so was not sure which is the best forum for this question and hence i posted it in both... if this is inappropiate here, please delete it / merge it.
thanks