InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 18:01:41 GMT20http://www.sqlservercentral.com/Forums/Topic1419322-391-1.aspx[quote][b]opc.three (2/13/2013)[/b][hr]I am not exactly sure what you're after but if you provide two sample XML documents and your expected results per your thoughts on the filtering and joining requirement you mentioned we can take it from there.[/quote]I have a scenario like, in the table few xml data types, example Location it is having country/State data in xml, all this information is related to user (Userid)<Location><Country Name="India"><State>HR</State><Country Name="UK"><Country Name="USA"></Location>We need to query the above xml based on input xml looks same as above, and one extra parameter is @Operatior = And/Or if we send AND then the user Location xml must contain all the input countries if it is or then if is enough to any one country exist in user table of Location field (xml).Please provider your inputs on this.Wed, 13 Feb 2013 23:44:56 GMTSQL*http://www.sqlservercentral.com/Forums/Topic1419322-391-1.aspxI am not exactly sure what you're after but if you provide two sample XML documents and your expected results per your thoughts on the filtering and joining requirement you mentioned we can take it from there.Wed, 13 Feb 2013 06:48:57 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1419322-391-1.aspxHi,I'm very new to XQuery's, here i need a situation to Join two different xml's and apply some filter conditions.From the below URL we can write the XQuery[url=http://www.datypic.com/books/xquery/chapter03.html][/url]But how can we use this in SQL Server.Wed, 13 Feb 2013 00:55:32 GMTSQL*