question

Here is the question, in brief it is about excluding / returning several nodes, depending on whether values are found in a reference table or not. I have a SQL Server table with XML datatype, which contains XML similar to this: 123 2012-11-14 00:00 red 11111 white 22222 green 333333 Then I have SelectedColors table which contains a list of colors, let's say White Blue What I would like to do is to parse the XML and match for each XML file in the database to match the colors in the SelectedColors table and output a XML file to disk which contains only the nodes which have the nodes matching the SelectedColors. SSIS would be used or any other method would be good as well. The output should be XML file saved to disk, which should look like this: 123 2012-11-14 00:00 white 22222