Jump to content

Jbalbo

Members
  • Content Count

    1
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Jbalbo

  • Rank
    Newbie
  1. Jbalbo

    ? on paring XML field

    Hi Having trouble parsing an XML field in SQL. Usually I do something like data.value('(/Data/...)[1]', 'varchar(10)') But not sure how to parse out say "Case" in the example below? <Parameters xmlns="http://www.www.com/WebFramework/WorkflowParameters.xsd"> <Parameter Name="ClientID" StringValue="12903166" /> <Parameter Name="Workflow_ActiveSlide" StringValue="317" /> <Parameter Name="Document_First_UserID" StringValue="8577430" /> <Parameter Name="Program" StringValue="120555" /> <Parameter Name="Workflow_ActiveUser" StringValue="9137070" /> <Parameter Name="Document" StringValue="14317336" /> <Parameter Name="Case" StringValue="12903171" /> <Parameter Name="ProgramSite" StringValue="152" /> </Parameters> Thanks
×
×
  • Create New...