SQL Server XML

Um, that previous message of mine, doing a simple explicit axis shred of an xml, I made a tiny adjustment to the code, and now it runs 60x faster, and I have no idea why! I used the [1] syntax instead of a separate call to value, changed the first ...

OK, I'm mystified.  Can I run the same kind of xpath queries and cross applies against XML that is stored in a table, or not? Please see example below. My situation is that I'm shredding some big-ish XML messages, and it was ...

Having an issue with outer apply that I do not understand. I'm parsing a fairly messy hierarchy in XML messages, and am running a lot of selects that cross-apply top levels to lower levels to shred them into ...

Hi, more newbie questions.  When I first read over the SQLServer XML documentation, I saw you could index XML.  I thought this would be great if you had a big single XML value that you were working on.  I have a 2.4mb XML ...

Hi, I want to add a few tags to XML variable as additional info. How to achive that? NOTE: I don't want to convert XML variable @list1 to varchar because it can be longer than varchar(8000). --Pseudo code ...

Thnaks for your help! I am building dynamic SQL command to send some commands to SQL Service Broker. I tried this way, but when 25,000 rows hit it, it never completed. DECLARE @SQL nvarchar(max) SELECT @SQL = COALESCE(@SQL, N'') ...

Thnaks for your help! I am building dynamic SQL command to send some commands to SQL Service Broker. I tried this way, but when 25,000 rows hit it, it never completed. DECLARE @SQL nvarchar(max) SELECT @SQL = COALESCE(@SQL, N'') ...

Hi, When I execute the following script on SQL Server 2005 SP2 : IF  EXISTS (select * from sys.objects where name = 'TEXTEST2' and type_desc = 'USER_TABLE') BEGIN DROP TABLE TEST.TEXTEST2 END CREATE TABLE TEST.TEXTEST2 (   ARR XML ); INSERT INTO TEST.TEXTEST2 (arr) VALUES ('<?xml version=''1.0'' ...

I'm processing EDI messages formatted as XML, a third party service does the translation, and the XML is not quite as convoluted as the original EDI, but neither is it normalized into fixed tables.  So, we have about four major ...

This is one record from xmlX field: <testclass xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">     <Age>32</Age>     <FirstName>Alicia</FirstName> ...

Hi I've read through SQL 2005 xml methods. I can't seem to find a function to extract xml to relational format where my element is unknown. xquery is based on the fact that the element is known, like "employee" etc. ...

I’m using SQL Server 2005, and this concerns making the xpath part of the XQUERY exist() function dynamic. I'm using the stored procedure below to make a Selection.  In the Where clause i use an XQUERY exist() function on my, xml_data column, which is of ...