https://www.infopathdev.com:443/forums/47.aspxFor questions concerning issues in the integration of SQL and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/17330.aspxThu, 06 Jul 2006 16:09:34 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:17330Kalyan Gaddam0https://www.infopathdev.com:443/forums/thread/17330.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=17330Hello, <br /><br />Yes you can query both structured data as well as XML data by using some methods like Nodes, Query in SQl XMl.<br /><br />You may also want to look into this link below.<br /<a target="_blank" href=http://msdn2.microsoft.com/en-us/library/ms203812.aspx>http://msdn2.microsoft.com/en-us/library/ms203812.aspx</a><br />and an example in the link below.<br /<a target="_blank" href=http://www.sitepoint.com/article/data-as-xml-sql-server>http://www.sitepoint.com/article/data-as-xml-sql-server</a>https://www.infopathdev.com:443/forums/thread/16827.aspxThu, 06 Jul 2006 13:06:25 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:16827AusDev0https://www.infopathdev.com:443/forums/thread/16827.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=16827Hi,<br /><br />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).<br /><br />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).<br /><br />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?<br /><br />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.<br /><br />Thanks<br />