Hi Let say I have the table of 2 fields, Project >> VCHAR2 XML >> XMLtype (containing XML data) In my XML field record 1, I have <Project ID='P01',...

punyavee napalai

02-02-2012 06:31 AM
punyavee napalai

I need to return a single row for each 'asset' with the parentId taken from the details node. This is what I have so far DECLARE @myXml AS XML SET...

Ken Cowley

12-07-2011 08:54 AM
Ken Cowley

I have a small web application in (created in VS2010) that connects to a sql server and provides the user with information like first name, last name...

Spero

09-05-2011 12:15 PM
Spero

I'm trying to import a single xml file into a single SQL 2008 R2 table using SSIS. The xml file has many elements so SSIS wants to put them into...

poorman

05-13-2011 01:11 PM
poorman

Hi In the follwing query, I use a very bad way to compute the last field (Position) using 1 + (ROW_NUMBER() OVER (ORDER BY att) - 1) /3 as...

pi

05-02-2011 01:32 PM
pi

I'm totally new to working with XML and I'm having trouble with what I believe to be a simple task. Daily I receive multiple files that contain xml...

Charles Sands

04-18-2011 09:17 AM
pi

I've recently begun receiving xml files and ran into a small problem that seems syntax related, but I simply can't find where it is. Below is the...

Dan

04-05-2011 03:20 AM
Erland Sommarskog

VTD-XML 2.10 is now released in Java, C#, C and C++. It can be downloaded...

dontcare

02-28-2011 08:59 PM
dontcare

I have id and xml columns in mytable. I want to update an element called myelement with the following UPDATE MyTable SET xml.modify ('replace value...

Roy

10-21-2010 05:51 AM
Michael Jones

I may have posted this in the wrong group. I have built a VB application that reads values from SQL server and uses one of the selected values to...

Spero

09-15-2010 08:23 PM
Spero

What is Happening? This message is to inform you that Microsoft will soon begin discontinuing newsgroups and transitioning users to Microsoft...

nntp@microsoft.com

09-11-2010 10:56 AM
nntp@microsoft.com

I thought this should be simple but it does not seem to work. I was trying to use FOR XML to generate XML data and XSD and SQLXMLBULKLOADLib to...

EPK

09-01-2010 07:20 AM
Aaron Dicks

Mitchell_Collen via SQLMonster.com wrote: The argument to the nodes method should be a path expression like e.g. '/blocked-process-report'. Your...

Martin Honnen

08-31-2010 09:08 AM
Mitchell_Collen via SQLMonster.com

I have never done this before and do not know where to start. Do you know how to parse out this TextData column into a readable string showing only...

Mitchell_Collen via SQLMonster.com

08-21-2010 09:20 AM
Martin Honnen

I have something like the following: declare @msg xml set @msg = '<Message><SubItem>Some Text</SubItem></Message>' I'd like to be able to extract...

Charles

08-04-2010 08:59 AM
Charles

I need to use XQuery to move a node between two XML data type fields... I know I can delete a node like this: SET...

Derek Hart

07-22-2010 08:33 PM
Derek Hart

This will give me a single line with a list of MyText attributes, recursively, under the...

Derek Hart

07-21-2010 01:12 PM
Martin Honnen

Hi, SQL 2005 encodes special characters like & as &amp; when outputting XML. Is there a way to get it to html encode all special characters, for...

£Jim

07-20-2010 04:12 PM
£Jim

Using SQL Server 2008 XML Data Type For A Column How can I recursively count all the nodes within a node... I have a node that is simply ...

Derek Hart

07-19-2010 01:31 PM
Derek Hart

Mary wrote: I am sure I suggested to use the 'Load' method, not the 'LoadXML' method. Also note that that suggestion is only possible if you use...

Martin Honnen

06-17-2010 02:29 PM
Mary

SQL Server 2008 (not r2) I am trying to get the Attribute values "TestAccount1" and "TestAccount2" from the below XML. I can't seem to get the...

SnapDive

06-14-2010 07:50 AM
Martin Honnen

XML Fragment @XMLData XML <table numcols="9" tag="TEST_TBL"> <Group fmt="center"> <data tag="ProductId"> <string>1234</string> </data> <data...

RJ Roberts

05-27-2010 05:20 PM
Bob

Hello, The following is my XML data &lt;specification&gt; &lt;item name=&quot;bore&quot; measure=&quot;mm&quot;&gt;96&lt;/item&gt; &lt;item...

bala

05-27-2010 11:20 AM
bala

I have two tables like this declare @Habits_new table(ID int,Habits xml default '<habits></habits>') declare @Habits_OLD table (ID...

Mukesh

05-12-2010 10:35 AM
bking

Date 5/4/2010 Starting in early summer 2010, Microsoft will begin progressively closing down the Microsoft public newsgroups to enrich conversations...

05-07-2010 05:50 AM

Hi, we are having some performance issues regarding xml shredding. At this point we are extracting data from xmls from nearly 60...

Johnny Persson

04-29-2010 02:26 PM
scmike

Hi All, I have an XML that has a layout as follows: <books> <book id='12' name='test1'> <authors> <author id='1' name = 'jill' /> <author id='2'...

Ben

04-20-2010 01:59 PM
Ben

hie friends..how to deploy web application in globus toolkit i mean to say how can we convert web service to a grid service??

Rohith Kumar

03-29-2010 02:44 AM
Rohith Kumar

THANK YOU FOR YOUR HELP. --From this XML declare @xml xml = '<root> <Identity docID="F230D2AA-BD00-4B68-BDDC-394F900AE583"...

Farmer

03-24-2010 03:37 PM
Farmer

Hi, I am having an issue with the ordering of my xml tags. Please see my example below: SELECT 1 as Tag, 0 as Parent, NULL as , NULL as , NULL as...

Benzine

03-04-2010 06:02 AM
Bob

hi all. I need to save the mass information from an xml in sql database from c # is not how. thanks -- desarrollo

paulcc84

03-03-2010 03:06 PM
Stefan Hoffmann

In a Asp.Net 3.5 application I need to read this XML chunk, inside a Stored Procedure (sql Server 2008): declare @xml varchar set @Xml...

Alberto

02-25-2010 08:47 AM
Alberto Vitiello

hi, in SQL Server 2008, I am trying to create a XML SCHEMA COLLECTION for the following xml, but I am getting the error Msg 2378, Level 16, State...

NMahmoud

02-19-2010 11:24 PM
jacobsebastian

I am creating an xml blob out of concatenated string data successfully in sql server 2008. I have been asked to now append results from another...

Carl Henthorn

02-10-2010 05:54 AM
Bob

Nuevo Modelo R4i para Comprar R4i para nintendo Ds, Ds Lite , Dsi y Dsi...

tesddalws

02-08-2010 01:06 PM
tesddalws

We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on the...

Mia

02-08-2010 11:28 AM
Mia

Many problems with performance and safety of your computer can be solved easily with an updated antivirus and recognized. Antivirus Free...

antivirus gratis

01-26-2010 04:09 PM
antivirus gratis

I have Windows Vista home premium. I recently installed a WNDR3300 NETGEAR router. Since then, I cannot open certain software programmes. I get...

Chalfont

01-12-2010 04:28 AM
Chalfont

Hi I'm trying to build an XML document from a relational schema. A lot of it works well, but I've having trouble building sub-elements which have...

Chloe C

12-29-2009 09:08 AM
Chloe C

Hi - I'm trying to parse the google analytics xml file returned from my data query. Under the item node, there are two tags - dxp:dimension and...

chris

12-18-2009 06:46 AM
Bob

Hello, In one database in my company. Previously the data in SQL Server, the tables were simple text and number formats and it was easy for me to...

SVCitian

12-14-2009 02:02 AM
Stefan Hoffmann

has anyone noticed any performance benefits from changing FOR XML EXPLICIT SELECTs to FOR XML PATH(...) SELECTs? I have some large EXPLICIT SELECTs...

Dan Holmes

11-30-2009 10:51 AM
Bob

Hi, I have an XML column in a table and i need to fetch the record based on some values, that are part of the XML as nodes. The xml format looks like...

Pavan

11-30-2009 07:32 AM
Pavan

Hi All, I have an input XML which needs to make an inner join with table on a specific field. I could not find the correct sysntax to do that. Here...

Ben

11-27-2009 04:35 AM
Lakhan Pal Garg

I'm beginning to learn XML with SQLServer. If SQLXML delivered the features in SQLServer 2000 and if it is deprecated in SQLServer 2005/2008...

rgn

11-25-2009 07:48 PM
Bob Beauchemin

Hi, I have a problem regarding inline selecting the right nodes from a tree. I would really like to write my statement like the...

Niels

11-19-2009 09:04 AM
Niels

We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on...

Mia

11-18-2009 10:30 AM
Mia

<SampleXML> <Tables> <Table value="abc" /> <Table value="123" /> </Tables> <Fields> <Field value="Name" /> <Field value="Price"...

Anonymous

11-16-2009 06:26 AM
Bob

Using SQL 2008, I have a table (tmpXML) with 2 columns CREATE TABLE .( IDENTITY(1,1) NOT NULL, NULL, CONSTRAINT PRIMARY KEY CLUSTERED ( ...

Ckirby

11-11-2009 06:32 AM
Bob

Hi all. I just can't get to the item values and hope anyone can help me. Here is the XML i have got into at one row tabel an XML datatype...

geir

11-05-2009 09:38 AM
Bob