Help Cannot update ID Witn Xquery

• mrp100461

  Grasshopper

  Points: 15

  More actions

  March 26, 2015 at 9:53 am

  #100204

  Please help I am trying to get the QubeFieldID to update where it The groupID is the same I have lost all my notes on XQuery so if you could help it would be helpful

  Update @temp

  Set xmlField.modify('replace value of (QubeField[GroupID = sql:variable("@groupID")] [QubeFieldID =sql:variable("@i")]/text())[1] with sql:variable("@newID")')

  Where @XmlField.exist('/ArrayOfQubeField/QubeField[GroupID = sql:variable("@groupID")] [QubeFieldID =sql:variable("@i")]')=1;

  Select XmlField fROM @temp

  XML

  '<ArrayOfQubeField xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

  <QubeField>

  <QubeFieldID>1</QubeFieldID>

  <GroupID>1</GroupID>

  <QubeFieldName>CaseID</QubeFieldName>

  <QubeFieldSelected>true</QubeFieldSelected>

  <Order>0</Order>

  </QubeField>

  <QubeField>

  <QubeFieldID>1</QubeFieldID>

  <GroupID>4</GroupID>

  <QubeFieldName>Insured Name</QubeFieldName>

  <QubeFieldSelected>true</QubeFieldSelected>

  <Order>1</Order>

  </QubeField>

  <QubeField>

  <QubeFieldID>2</QubeFieldID>

  <GroupID>3</GroupID>

  <QubeFieldName>Insurer Town</QubeFieldName>

  <QubeFieldSelected>true</QubeFieldSelected>

  <Order>2</Order>

  </QubeField>

  <QubeField>

  <QubeFieldID>1</QubeFieldID>

  <GroupID>3</GroupID>

  <QubeFieldName>Insurer Name</QubeFieldName>

  <QubeFieldSelected>true</QubeFieldSelected>

  <Order>3</Order>

  </QubeField>

  <QubeField>

  <QubeFieldID>13</QubeFieldID>

  <GroupID>1</GroupID>

  <QubeFieldName>Date Migrated</QubeFieldName>

  <QubeFieldSelected>true</QubeFieldSelected>

  <Order>4</Order>

  </QubeField>

  <QubeField>

  <QubeFieldID>16</QubeFieldID>

  <GroupID>1</GroupID>

  <QubeFieldName>Date Of Loss</QubeFieldName>

  <QubeFieldSelected>true</QubeFieldSelected>

  <Order>5</Order>

  </QubeField>

  </ArrayOfQubeField>

• Alan Burstein

  SSC Guru

  Points: 61141

  More actions

  March 27, 2015 at 2:52 am

  #1786775

  This is a somewhat ambiguous request. Can you explain what the @NewID, @GroupID, and @i variables are for. We're those something you were attempting to use to solve this problem?

  "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

  -- Itzik Ben-Gan 2001