InfoPath Dev

Hi,

We are storing the entire xml of an infopath form as a string alongside structured data in a sql 2005 db. The project is a reporting one and we need to retrieve data from the infopath forms for display in the reports (along with structured data).

We need to be able to build a query which retrieves both structured data from the tables and xml data from the xml string (also within a table).

So the question is: can you query an xml string stored within a table from with a stored proc? If so can you combine this query (I'm guessing this will be XPath) with a standard sql query to return both types of data?

The MS devs (yes actual MS employees) I'm working with don't so it will be interesting to see if anyone can suggest a solution.

Thanks

Hello,

Yes you can query both structured data as well as XML data by using some methods like Nodes, Query in SQl XMl.

You may also want to look into this link below.
http://msdn2.microsoft.com/en-us/library/ms203812.aspx
and an example in the link below.
http://www.sitepoint.com/article/data-as-xml-sql-server