Hi I'm trying to build an XML document from a relational schema. A lot of it works well, but I

Hi - I'm trying to parse the google analytics xml file returned from my data query. Under the

Hello, In one database in my company. Previously the data in SQL Server, the tables were simple text

has anyone noticed any performance benefits from changing FOR XML EXPLICIT SELECTs to FOR XML PATH(..

Hi, I have an XML column in a table and i need to fetch the record based on some values, that are

Hi All, I have an input XML which needs to make an inner join with table on a specific field. I could

I'm beginning to learn XML with SQLServer. If SQLXML delivered the features in SQLServer 2000 and

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

We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?

<SampleXML> <Tables> <Table value="abc" /> <Table value="123

Using SQL 2008, I have a table (tmpXML) with 2 columns CREATE TABLE [dbo].[tmpXML]( [pk] [int]

Hi all. I just can't get to the item values and hope anyone can help me. Here is the XML i have

Using SQL Server 2005 --First the Schema Collection and table definition CREATE XML SCHEMA COLLECTION

Can anyone point me to an example of how to setup an SSIS package that would consume a webservice,

Before analyzing xml or html management, some more work has to be done in order to develop database

I am an XML rookie. Given that, I have a table called Testdata with columns defined as [ID] [int]

Xponent has released the first beta version of CAX, a caching API for XML. CAX extends the

Hi All, I have a content managed site that I need to create an sitemap XML for. The pages can be

Please help me to filter out only CustomerRet elements that DO NOT have child ParentRef element usign

I have a XML node that is padded with leading spaces, when I use openxml to access the XML file, the

Sql Server 2005: The following tsql works fine, but I need to know if it is documented syntax. My

Hi.. I am trying to add an attribute to the end element.I believe that attributes to the end element

Dear Sirs, �Ҵ���ʹ��XML��ʽ�탦��Data�����ڙz���r�������ڡ����ֻ��ִ���ȗl����Ӧ�����дSQL ���? Ո���ˡ� XML��λ�еă

Sql Server 2005: The following query works fine with the UPS .xml doc that follows, but only if I

I need to use OpenXML() to return an Edge Table representation of an xml doc. Is it safe to assume

Currently I have been able to successfully parse part of the information I am attempting to retrieve

Dear all Since a while I am getting an error while trying to backup a database. The job should be

Sql Server 2005: Requirement: return results of openxml() to an Edge Table. Function body: openxml(@

Is there any way to convert a delimited text file into XML? Appreciate any help.

I've been studying XMLBULKLOAD for the past 2 weeks, and have succeed with many of the XML