question

sibir1us avatar image
sibir1us asked

Exclude XML nodes based on a dataset

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
xmlparsing
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.