Subject:SQL Server 2005 XQuery help Author:Anees Shaik Date:07 Nov 2007 03:47 PM
I am new to XQuery. I am trying to check the value of one field and then if it mathces I want to associate data in another field to the target element in the resulting XML file. I am using a xml schema. How can I do this using the mapper in XQuery builder.
Subject:SQL Server 2005 XQuery help Author:Alberto Massari Date:14 Nov 2007 02:41 AM
just right click again and pick "Conditional block" followed by "=".
Drag the Question node to the first input, double click on the second and enter "NSN".
Right click again on the middle pane, and pick the "If block" menu entry.
Drag the output of the "=" block to the input port of the "if", and the top output of the "if" to the NSN node