Ask - WHERE clause in XML

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Ask

Ask questions, discuss or help others by answering


	Ask a question


	Subscribe..

WHERE clause in XML

Jun 17 2012 12:00AM by kaluchemtech

Hello Sir,

I was trying to search the solution of WHERE clause while reading XML data in SQL Server but wasn't find any luck. Can you please help me?

We have two "section" tag in that XML file and try to pass it in WHERE condition. sometime I have to read the "Section" which has value "Dilution Corrected Concentrations" in the "title" element of "section" tag and sometime we try to read the "section" tag which has "Fully Quantitative Concentrations" in the "title" element of "section" tag so I have to pass "Dilution Corrected Concentrations" or "Fully Quantitative Concentrations" in WHERE condition and wants to read "section" tag based on WHERE clause.

Here is the XML I am using.

<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="plasmalab.xsl"?>
<plasmalab maxcols="9" showtime="1" breakaftersample="1">
   <section title="Dilution Corrected Concentrations">
      <results>
         <sample user="1.000" label="S0     (S0)" time="06/09/2012 02:54:33 PM">
            <run type="nrh" id="1" time="14:55:41">
               <analyte type="nr_is">99%</analyte>
               <analyte type="nr">-0.007</analyte>
               <analyte type="nr">0.022</analyte>
               <analyte type="nr">0.000</analyte>
               <analyte type="nr">0.176</analyte>
               <analyte type="nr">-0.306</analyte>
               <analyte type="nr">-0.146</analyte>
               <analyte type="nr">-0.232</analyte>
               <analyte type="nr">-0.185</analyte>
               <analyte type="nr">-18.430</analyte>
               <analyte type="nr">1.459</analyte>
               <analyte type="nr">0.000</analyte>
               <analyte type="nr">0.000</analyte>
               <analyte type="nr">0.756</analyte>
               <analyte type="nr">-1.100</analyte>
               <analyte type="nr">1.927</analyte>
               <analyte type="nr_is">99%</analyte>
               <analyte type="nr">-0.034</analyte>
               <analyte type="nr">0.002</analyte>
               <analyte type="nr">0.020</analyte>
               <analyte type="nr">0.052</analyte>
               <analyte type="nr">-0.552</analyte>
               <analyte type="nr">-0.024</analyte>
               <analyte type="nr">0.219</analyte>
               <analyte type="nr">0.402</analyte>
               <analyte type="nr">-0.009</analyte>
               <analyte type="nr">-0.014</analyte>
               <analyte type="nr">-0.007</analyte>
               <analyte type="nr">-0.023</analyte>
               <analyte type="nr">-0.081</analyte>
               <analyte type="nr">-0.056</analyte>
               <analyte type="nr">0.066</analyte>
               <analyte type="nr">0.006</analyte>
               <analyte type="nr">0.312</analyte>
               <analyte type="nr">0.066</analyte>
               <analyte type="nr">0.052</analyte>
               <analyte type="nr">-0.018</analyte>
               <analyte type="nr">-0.011</analyte>
               <analyte type="nr">-0.002</analyte>
               <analyte type="nr">-0.012</analyte>
               <analyte type="nr">-0.000</analyte>
               <analyte type="nr">0.011</analyte>
               <analyte type="nr">-0.000</analyte>
               <analyte type="nr">0.000</analyte>
               <analyte type="nr_is">99%</analyte>
               <analyte type="nr">0.193</analyte>
               <analyte type="nr">0.001</analyte>
               <analyte type="nr">-0.144</analyte>
               <analyte type="nr">0.193</analyte>
               <analyte type="nr">0.001</analyte>
               <analyte type="nr">0.013</analyte>
               <analyte type="nr">0.002</analyte>
               <analyte type="nr">0.002</analyte>
               <analyte type="nr">-0.039</analyte>
               <analyte type="nr">0.004</analyte>
               <analyte type="nr_is">99%</analyte>
               <analyte type="nr_is">100%</analyte>
               <analyte type="nr">0.007</analyte>
               <analyte type="nr">-0.000</analyte>
               <analyte type="nr">-0.002</analyte>
               <analyte type="nr">-0.003</analyte>
               <analyte type="nr">-0.004</analyte>
               <analyte type="nr_is">99%</analyte>
               <analyte type="nr">-0.001</analyte>
               <analyte type="nr">-0.001</analyte>
            </run>
            <run type="nrh" id="2" time="14:56:49">
               <analyte type="nr_is">100%</analyte>
               <analyte type="nr">-0.013</analyte>
               <analyte type="nr">0.110</analyte>
               <analyte type="nr">0.000</analyte>
               <analyte type="nr">0.585</analyte>
               <analyte type="nr">-0.046</analyte>
               <analyte type="nr">-0.511</analyte>
               <analyte type="nr">-0.288</analyte>
               <analyte type="nr">0.019</analyte>
               <analyte type="nr">37.320</analyte>
               <analyte type="nr">-0.855</analyte>
               <analyte type="nr">0.000</analyte>
               <analyte type="nr">0.000</analyte>
               <analyte type="nr">0.874</analyte>
               <analyte type="nr">-2.488</analyte>
               <analyte type="nr">0.528</analyte>
               <analyte type="nr_is">100%</analyte>
               <analyte type="nr">0.009</analyte>
               <analyte type="nr">0.114</analyte>
               <analyte type="nr">-0.016</analyte>
               <analyte type="nr">-0.118</analyte>
               <analyte type="nr">0.480</analyte>
               <analyte type="nr">0.004</analyte>
               <analyte type="nr">0.562</analyte>
               <analyte type="nr">-0.266</analyte>
               <analyte type="nr">0.011</analyte>
               <analyte type="nr">0.015</analyte>
               <analyte type="nr">0.014</analyte>
               <analyte type="nr">-0.004</analyte>
               <analyte type="nr">-0.002</analyte>
               <analyte type="nr">0.004</analyte>
               <analyte type="nr">-0.210</analyte>
               <analyte type="nr">-0.000</analyte>
               <analyte type="nr">-0.080</analyte>
               <analyte type="nr">-0.209</analyte>
               <analyte type="nr">1.207</analyte>
               <analyte type="nr">0.030</analyte>
               <analyte type="nr">0.002</analyte>
               <analyte type="nr">0.001</analyte>
               <analyte type="nr">0.003</analyte>
               <analyte type="nr">-0.010</analyte>
               <analyte type="nr">-0.008</analyte>
               <analyte type="nr">-0.008</analyte>
               <analyte type="nr">0.001</analyte>
               <analyte type="nr_is">100%</analyte>
               <analyte type="nr">-0.112</analyte>
               <analyte type="nr">0.001</analyte>
               <analyte type="nr">0.082</analyte>
               <analyte type="nr">-0.112</analyte>
               <analyte type="nr">-0.000</analyte>
               <analyte type="nr">-0.023</analyte>
               <analyte type="nr">0.015</analyte>
               <analyte type="nr">0.001</analyte>
               <analyte type="nr">0.036</analyte>
               <analyte type="nr">0.000</analyte>
               <analyte type="nr_is">100%</analyte>
               <analyte type="nr_is">100%</analyte>
               <analyte type="nr">0.001</analyte>
               <analyte type="nr">-0.004</analyte>
               <analyte type="nr">-0.001</analyte>
               <analyte type="nr">0.003</analyte>
               <analyte type="nr">0.004</analyte>
               <analyte type="nr_is">100%</analyte>
               <analyte type="nr">-0.000</analyte>
               <analyte type="nr">-0.001</analyte>
            </run>
         </sample>
         <sample user="1.000" label="S1     (S)" time="06/09/2012 03:02:25 PM">
            <run type="nrh" id="1" time="15:03:33">
               <analyte type="nr_is">98%</analyte>
               <analyte type="nr">0.946</analyte>
               <analyte type="nr">9.608</analyte>
               <analyte type="nr">0.000</analyte>
               <analyte type="nr">502.100</analyte>
               <analyte type="nr">492.100</analyte>
               <analyte type="nr">479.300</analyte>
               <analyte type="nr">487.300</analyte>
               <analyte type="nr">20.150</analyte>
               <analyte type="nr">-6.819</analyte>
               <analyte type="nr">48.630</analyte>
               <analyte type="nr">0.000</analyte>
               <analyte type="nr">0.000</analyte>
               <analyte type="nr">497.600</analyte>
               <analyte type="nr">482.100</analyte>
               <analyte type="nr">469.000</analyte>
               <analyte type="nr_is">99%</analyte>
               <analyte type="nr">4.548</analyte>
               <analyte type="nr">4.821</analyte>
               <analyte type="nr">1.983</analyte>
               <analyte type="nr">0.004</analyte>
               <analyte type="nr">203.000</analyte>
               <analyte type="nr">0.963</analyte>
               <analyte type="nr">202.300</analyte>
               <analyte type="nr">202.800</analyte>
               <analyte type="nr">0.924</analyte>
               <analyte type="nr">0.909</analyte>
               <analyte type="nr">1.881</analyte>
               <analyte type="nr">2.051</analyte>
               <analyte type="nr">2.674</analyte>
               <analyte type="nr">0.729</analyte>
               <analyte type="nr">4.887</analyte>
               <analyte type="nr">0.026</analyte>
               <analyte type="nr">5.036</analyte>
               <analyte type="nr">4.872</analyte>
               <analyte type="nr">-0.269</analyte>
               <analyte type="nr">0.863</analyte>
               <analyte type="nr">0.902</analyte>
               <analyte type="nr">1.574</analyte>
               <analyte type="nr">4.627</analyte>
               <analyte type="nr">3.913</analyte>
               <analyte type="nr">4.680</analyte>
               <analyte type="nr">4.476</analyte>
               <analyte type="nr">-0.001</analyte>
               <analyte type="nr_is">98%</analyte>
               <analyte type="nr">0.655</analyte>
               <analyte type="nr">0.979</analyte>
               <analyte type="nr">0.030</analyte>
               <analyte type="nr">0.655</analyte>
               <analyte type="nr">0.976</analyte>
               <analyte type="nr">0.875</analyte>
               <analyte type="nr">4.623</analyte>
               <analyte type="nr">1.891</analyte>
               <analyte type="nr">9.442</analyte>
               <analyte type="nr">9.486</analyte>
               <analyte type="nr_is">98%</analyte>
               <analyte type="nr_is">98%</analyte>
               <analyte type="nr">0.936</analyte>
               <analyte type="nr">1.011</analyte>
               <analyte type="nr">0.948</analyte>
               <analyte type="nr">0.949</analyte>
               <analyte type="nr">0.956</analyte>
               <analyte type="nr_is">98%</analyte>
               <analyte type="nr">0.599</analyte>
               <analyte type="nr">0.909</analyte>
            </run>
            <run type="nrh" id="2" time="15:04:40">
               <analyte type="nr_is">99%</analyte>
               <analyte type="nr">0.951</analyte>
               <analyte type="nr">10.490</analyte>
               <analyte type="nr">0.000</analyte>
               <analyte type="nr">496.000</analyte>
               <analyte type="nr">488.000</analyte>
               <analyte type="nr">479.100</analyte>
               <analyte type="nr">485.100</analyte>
               <analyte type="nr">20.280</analyte>
               <analyte type="nr">-8.115</analyte>
               <analyte type="nr">50.440</analyte>
               <analyte type="nr">0.000</analyte>
               <analyte type="nr">0.000</analyte>
               <analyte type="nr">492.600</analyte>
               <analyte type="nr">473.600</analyte>
               <analyte type="nr">476.800</analyte>
               <analyte type="nr_is">100%</analyte>
               <analyte type="nr">4.592</analyte>
               <analyte type="nr">4.785</analyte>
               <analyte type="nr">1.872</analyte>
               <analyte type="nr">-0.125</analyte>
               <analyte type="nr">203.000</analyte>
               <analyte type="nr">1.005</analyte>
               <analyte type="nr">202.300</analyte>
               <analyte type="nr">200.400</analyte>
               <analyte type="nr">0.939</analyte>
               <analyte type="nr">0.995</analyte>
               <analyte type="nr">2.039</analyte>
               <analyte type="nr">1.963</analyte>
               <analyte type="nr">2.711</analyte>
               <analyte type="nr">0.874</analyte>
               <analyte type="nr">4.490</analyte>
               <analyte type="nr">0.008</analyte>
               <analyte type="nr">4.726</analyte>
               <analyte type="nr">4.475</analyte>
               <analyte type="nr">2.073</analyte>
               <analyte type="nr">0.821</analyte>
               <analyte type="nr">0.856</analyte>
               <analyte type="nr">1.549</analyte>
               <analyte type="nr">4.412</analyte>
               <analyte type="nr">3.698</analyte>
               <analyte type="nr">4.594</analyte>
               <analyte type="nr">4.527</analyte>
               <analyte type="nr">-0.001</analyte>
               <analyte type="nr_is">99%</analyte>
               <analyte type="nr">0.600</analyte>
               <analyte type="nr">0.915</analyte>
               <analyte type="nr">0.099</analyte>
               <analyte type="nr">0.604</analyte>
               <analyte type="nr">0.995</analyte>
               <analyte type="nr">0.985</analyte>
               <analyte type="nr">4.601</analyte>
               <analyte type="nr">1.827</analyte>
               <analyte type="nr">9.282</analyte>
               <analyte type="nr">9.203</analyte>
               <analyte type="nr_is">98%</analyte>
               <analyte type="nr_is">98%</analyte>
               <analyte type="nr">0.991</analyte>
               <analyte type="nr">0.988</analyte>
               <analyte type="nr">0.952</analyte>
               <analyte type="nr">0.954</analyte>
               <analyte type="nr">0.938</analyte>
               <analyte type="nr_is">99%</analyte>
               <analyte type="nr">0.677</analyte>
               <analyte type="nr">0.903</analyte>
            </run>
            <run type="nrh" id="3" time="15:05:48">
               <analyte type="nr_is">99%</analyte>
               <analyte type="nr">1.134</analyte>
               <analyte type="nr">9.124</analyte>
               <analyte type="nr">0.000</analyte>
               <analyte type="nr">488.300</analyte>
               <analyte type="nr">483.200</analyte>
               <analyte type="nr">470.000</analyte>
               <analyte type="nr">475.600</analyte>
               <analyte type="nr">19.690</analyte>
               <analyte type="nr">-7.779</analyte>
               <analyte type="nr">48.110</analyte>
               <analyte type="nr">0.000</analyte>
               <analyte type="nr">0.000</analyte>
               <analyte type="nr">489.800</analyte>
               <analyte type="nr">512.300</analyte>
               <analyte type="nr">458.800</analyte>
               <analyte type="nr_is">99%</analyte>
               <analyte type="nr">4.669</analyte>
               <analyte type="nr">4.641</analyte>
               <analyte type="nr">1.851</analyte>
               <analyte type="nr">0.057</analyte>
               <analyte type="nr">198.000</analyte>
               <analyte type="nr">0.897</analyte>
               <analyte type="nr">198.300</analyte>
               <analyte type="nr">200.500</analyte>
               <analyte type="nr">0.975</analyte>
               <analyte type="nr">0.945</analyte>
               <analyte type="nr">1.933</analyte>
               <analyte type="nr">1.947</analyte>
               <analyte type="nr">2.609</analyte>
               <analyte type="nr">1.069</analyte>
               <analyte type="nr">4.958</analyte>
               <analyte type="nr">-0.017</analyte>
               <analyte type="nr">5.058</analyte>
               <analyte type="nr">4.932</analyte>
               <analyte type="nr">0.349</analyte>
               <analyte type="nr">0.938</analyte>
               <analyte type="nr">0.851</analyte>
               <analyte type="nr">1.549</analyte>
               <analyte type="nr">4.439</analyte>
               <analyte type="nr">3.868</analyte>
               <analyte type="nr">4.487</analyte>
               <analyte type="nr">4.588</analyte>
               <analyte type="nr">-0.000</analyte>
               <analyte type="nr_is">100%</analyte>
               <analyte type="nr">1.007</analyte>
               <analyte type="nr">0.928</analyte>
               <analyte type="nr">-0.193</analyte>
               <analyte type="nr">1.011</analyte>
               <analyte type="nr">0.889</analyte>
               <analyte type="nr">1.013</analyte>
               <analyte type="nr">4.553</analyte>
               <analyte type="nr">1.795</analyte>
               <analyte type="nr">9.105</analyte>
               <analyte type="nr">9.039</analyte>
               <analyte type="nr_is">99%</analyte>
               <analyte type="nr_is">99%</analyte>
               <analyte type="nr">0.946</analyte>
               <analyte type="nr">0.946</analyte>
               <analyte type="nr">0.897</analyte>
               <analyte type="nr">0.920</analyte>
               <analyte type="nr">0.908</analyte>
               <analyte type="nr_is">99%</analyte>
               <analyte type="nr">0.724</analyte>
               <analyte type="nr">0.900</analyte>
            </run>
            <run type="nrh_m" id="x">
               <analyte type="nrs_is">99%</analyte>
               <analyte type="nrs">1.010</analyte>
               <analyte type="nrs">9.739</analyte>
               <analyte type="nrs">0.000</analyte>
               <analyte type="nrs">495.500</analyte>
               <analyte type="nrs">487.800</analyte>
               <analyte type="nrs">476.100</analyte>
               <analyte type="nrs">482.700</analyte>
               <analyte type="nrs">20.040</analyte>
               <analyte type="nrs">-7.571</analyte>
               <analyte type="nrs">49.060</analyte>
               <analyte type="nrs">0.000</analyte>
               <analyte type="nrs">0.000</analyte>
               <analyte type="nrs">493.300</analyte>
               <analyte type="nrs">489.300</analyte>
               <analyte type="nrs">468.200</analyte>
               <analyte type="nrs_is">99%</analyte>
               <analyte type="nrs">4.603</analyte>
               <analyte type="nrs">4.749</analyte>
               <analyte type="nrs">1.902</analyte>
               <analyte type="nrs">-0.021</analyte>
               <analyte type="nrs">201.400</analyte>
               <analyte type="nrs">0.955</analyte>
               <analyte type="nrs">201.000</analyte>
               <analyte type="nrs">201.300</analyte>
               <analyte type="nrs">0.946</analyte>
               <analyte type="nrs">0.950</analyte>
               <analyte type="nrs">1.951</analyte>
               <analyte type="nrs">1.987</analyte>
               <analyte type="nrs">2.664</analyte>
               <analyte type="nrs">0.891</analyte>
               <analyte type="nrs">4.778</analyte>
               <analyte type="nrs">0.006</analyte>
               <analyte type="nrs">4.940</analyte>
               <analyte type="nrs">4.760</analyte>
               <analyte type="nrs">0.718</analyte>
               <analyte type="nrs">0.874</analyte>
               <analyte type="nrs">0.870</analyte>
               <analyte type="nrs">1.557</analyte>
               <analyte type="nrs">4.493</analyte>
               <analyte type="nrs">3.826</analyte>
               <analyte type="nrs">4.587</analyte>
               <analyte type="nrs">4.530</analyte>
               <analyte type="nrs">-0.001</analyte>
               <analyte type="nrs_is">99%</analyte>
               <analyte type="nrs">0.754</analyte>
               <analyte type="nrs">0.941</analyte>
               <analyte type="nrs">-0.021</analyte>
               <analyte type="nrs">0.757</analyte>
               <analyte type="nrs">0.954</analyte>
               <analyte type="nrs">0.957</analyte>
               <analyte type="nrs">4.592</analyte>
               <analyte type="nrs">1.838</analyte>
               <analyte type="nrs">9.276</analyte>
               <analyte type="nrs">9.242</analyte>
               <analyte type="nrs_is">98%</analyte>
               <analyte type="nrs_is">98%</analyte>
               <analyte type="nrs">0.958</analyte>
               <analyte type="nrs">0.982</analyte>
               <analyte type="nrs">0.932</analyte>
               <analyte type="nrs">0.941</analyte>
               <analyte type="nrs">0.934</analyte>
               <analyte type="nrs_is">98%</analyte>
               <analyte type="nrs">0.667</analyte>
               <analyte type="nrs">0.904</analyte>
            </run>
            <run type="nrh_r" id="%RSD">
               <analyte type="nrs_is">0</analyte>
               <analyte type="nrs">10.590</analyte>
               <analyte type="nrs">7.083</analyte>
               <analyte type="nrs">0.000</analyte>
               <analyte type="nrs">1.399</analyte>
               <analyte type="nrs">0.913</analyte>
               <analyte type="nrs">1.117</analyte>
               <analyte type="nrs">1.290</analyte>
               <analyte type="nrs">1.545</analyte>
               <analyte type="nrs">8.887</analyte>
               <analyte type="nrs">2.488</analyte>
               <analyte type="nrs">0.000</analyte>
               <analyte type="nrs">0.000</analyte>
               <analyte type="nrs">0.798</analyte>
               <analyte type="nrs">4.150</analyte>
               <analyte type="nrs">1.921</analyte>
               <analyte type="nrs_is">1</analyte>
               <analyte type="nrs">1.326</analyte>
               <analyte type="nrs">2.003</analyte>
               <analyte type="nrs">3.726</analyte>
               <analyte type="nrs">436.600</analyte>
               <analyte type="nrs">1.427</analyte>
               <analyte type="nrs">5.737</analyte>
               <analyte type="nrs">1.144</analyte>
               <analyte type="nrs">0.670</analyte>
               <analyte type="nrs">2.756</analyte>
               <analyte type="nrs">4.564</analyte>
               <analyte type="nrs">4.123</analyte>
               <analyte type="nrs">2.832</analyte>
               <analyte type="nrs">1.941</analyte>
               <analyte type="nrs">19.140</analyte>
               <analyte type="nrs">5.277</analyte>
               <analyte type="nrs">372.800</analyte>
               <analyte type="nrs">3.755</analyte>
               <analyte type="nrs">5.217</analyte>
               <analyte type="nrs">169.100</analyte>
               <analyte type="nrs">6.794</analyte>
               <analyte type="nrs">3.261</analyte>
               <analyte type="nrs">0.915</analyte>
               <analyte type="nrs">2.617</analyte>
               <analyte type="nrs">2.963</analyte>
               <analyte type="nrs">2.117</analyte>
               <analyte type="nrs">1.232</analyte>
               <analyte type="nrs">86.470</analyte>
               <analyte type="nrs_is">1</analyte>
               <analyte type="nrs">29.260</analyte>
               <analyte type="nrs">3.618</analyte>
               <analyte type="nrs">717.300</analyte>
               <analyte type="nrs">29.280</analyte>
               <analyte type="nrs">5.900</analyte>
               <analyte type="nrs">7.607</analyte>
               <analyte type="nrs">0.782</analyte>
               <analyte type="nrs">2.660</analyte>
               <analyte type="nrs">1.816</analyte>
               <analyte type="nrs">2.449</analyte>
               <analyte type="nrs_is">1</analyte>
               <analyte type="nrs_is">1</analyte>
               <analyte type="nrs">3.069</analyte>
               <analyte type="nrs">3.373</analyte>
               <analyte type="nrs">3.283</analyte>
               <analyte type="nrs">1.971</analyte>
               <analyte type="nrs">2.608</analyte>
               <analyte type="nrs_is">1</analyte>
               <analyte type="nrs">9.500</analyte>
               <analyte type="nrs">0.495</analyte>
            </run>
         </sample>
      </results>
   </section>
   <section title="Fully Quantitative Concentrations">
      <defined_concentrations transient="0" type="fq">
         <sample id="3" label="S1     (S)">
            <analyte>1.000</analyte>
            <analyte>10.000</analyte>
            <analyte>500.000</analyte>
            <analyte>500.000</analyte>
            <analyte>500.000</analyte>
            <analyte>500.000</analyte>
            <analyte>20.000</analyte>
            <analyte>10.000</analyte>
            <analyte>50.000</analyte>
            <analyte>500.000</analyte>
            <analyte>500.000</analyte>
            <analyte>500.000</analyte>
            <analyte>5.000</analyte>
            <analyte>5.000</analyte>
            <analyte>2.000</analyte>
            <analyte>1.000</analyte>
            <analyte>200.000</analyte>
            <analyte>200.000</analyte>
            <analyte>200.000</analyte>
            <analyte>1.000</analyte>
            <analyte>1.000</analyte>
            <analyte>1.000</analyte>
            <analyte>1.000</analyte>
            <analyte>2.000</analyte>
            <analyte>2.000</analyte>
            <analyte>2.000</analyte>
            <analyte>2.000</analyte>
            <analyte>2.000</analyte>
            <analyte>1.000</analyte>
            <analyte>5.000</analyte>
            <analyte>5.000</analyte>
            <analyte>5.000</analyte>
            <analyte>1.000</analyte>
            <analyte>1.000</analyte>
            <analyte>5.000</analyte>
            <analyte>5.000</analyte>
            <analyte>5.000</analyte>
            <analyte>5.000</analyte>
            <analyte>5.000</analyte>
            <analyte>1.000</analyte>
            <analyte>1.000</analyte>
            <analyte>1.000</analyte>
            <analyte>1.000</analyte>
            <analyte>1.000</analyte>
            <analyte>5.000</analyte>
            <analyte>2.000</analyte>
            <analyte>10.000</analyte>
            <analyte>10.000</analyte>
            <analyte>1.000</analyte>
            <analyte>1.000</analyte>
            <analyte>1.000</analyte>
            <analyte>1.000</analyte>
            <analyte>1.000</analyte>
            <analyte>1.000</analyte>
            <analyte>1.000</analyte>
         </sample>
         <sample id="4" label="S2     (S)">
            <analyte>125.000</analyte>
            <analyte>125.000</analyte>
            <analyte>12500.000</analyte>
            <analyte>12500.000</analyte>
            <analyte>12500.000</analyte>
            <analyte>12500.000</analyte>
            <analyte>2500.000</analyte>
            <analyte>125.000</analyte>
            <analyte>2500.000</analyte>
            <analyte>6250.000</analyte>
            <analyte>12500.000</analyte>
            <analyte>12500.000</analyte>
            <analyte>125.000</analyte>
            <analyte>125.000</analyte>
            <analyte>125.000</analyte>
            <analyte>250.000</analyte>
            <analyte>6250.000</analyte>
            <analyte>6250.000</analyte>
            <analyte>6250.000</analyte>
            <analyte>125.000</analyte>
            <analyte>125.000</analyte>
            <analyte>125.000</analyte>
            <analyte>125.000</analyte>
            <analyte>250.000</analyte>
            <analyte>250.000</analyte>
            <analyte>250.000</analyte>
            <analyte>250.000</analyte>
            <analyte>250.000</analyte>
            <analyte>125.000</analyte>
            <analyte>125.000</analyte>
            <analyte>125.000</analyte>
            <analyte>125.000</analyte>
            <analyte>125.000</analyte>
            <analyte>125.000</analyte>
            <analyte>125.000</analyte>
            <analyte>125.000</analyte>
            <analyte>125.000</analyte>
            <analyte>125.000</analyte>
            <analyte>125.000</analyte>
            <analyte>125.000</analyte>
            <analyte>125.000</analyte>
            <analyte>125.000</analyte>
            <analyte>125.000</analyte>
            <analyte>125.000</analyte>
            <analyte>125.000</analyte>
            <analyte>125.000</analyte>
            <analyte>625.000</analyte>
            <analyte>625.000</analyte>
            <analyte>125.000</analyte>
            <analyte>125.000</analyte>
            <analyte>125.000</analyte>
            <analyte>125.000</analyte>
            <analyte>125.000</analyte>
            <analyte>125.000</analyte>
            <analyte>125.000</analyte>
         </sample>
      </defined_concentrations>
   </section>
</plasmalab>

Submitted under: Microsoft SQL Server · XML · XQUERY · ·

Previous: Getting "Arithmetic overflow error" with smalldatetime variable
Next: Allocate Qty using FIFO Method in SQL Server 2008

kaluchemtech

1059 · 0% · 24

3 Replies

write something like below

declare @para1 varchar(50)='Dilution Corrected Concentrations'

select case  when @para1 = 'Fully Quantitative Concentrations' then
    			o.value('(defined_concentrations/sample[1]/analyte[1])[1]', 'VARCHAR(20)') 
    		when @para1 = 'Dilution Corrected Concentrations' then
    			o.value('(results/sample/run/analyte[1])[1]', 'VARCHAR(20)')
    		else null end AS tmp
from @x.nodes('/plasmalab/section[@title= sql:variable("@para1")]') as a(o)

commented on Jun 18 2012 12:03PM

Mitesh Modi

18 · 10% · 3078

Hello Mitesh,

Thank you very much for your update. Actually the XML given is just a 10% part of the actual XML. It is not decided that which section comes first so I can't go with static solution like "Sample[1]" or "analyte[1]" etc. I need to query XML itself and check value with that only. Can you please help us in this situation?

commented on Jun 18 2012 10:51PM

kaluchemtech

1059 · 0% · 24

If you do not know the element name in advance you can use the XQuery function local-name() to read values based on a variable. The requirement does not seem to be complicated. What is the expected result based on the given input XML?

commented on Aug 10 2012 2:17AM

Jacob Sebastian

1 · 100% · 32004

Your Reply

Sign Up or Login to post a comment.