3-way join -> xml tree
Thu, 28 Feb 2008 12:57:24 +0100
How do I join 3 tables to get the following xml structure:
<roottable>
<id>111</id>
<data>aaa</data>
<childtable1>
<id>222</id>
<data>bbb</data>
</childtable1>
<childtable1>
<id>333</id>
<data>ccc</data>
</childtable1>
<childtable2>
<id>444</id>
<data>ddd</data>
...
|
Query an xml column
Wed, 27 Feb 2008 18:19:19 -0800 (PST)
I am having trouble querying a column in my sql server database that
contains the following xml
<BaseData xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xsi:type="CarData"><RentalCars>123</RentalCars><LeaseCars>22</
LeaseCars><JunkCars>5</JunkCars></BaseData ...
|
configuring Report Server
Wed, 27 Feb 2008 06:37:56 GMT
I just installed SQL Server 2005 Express Advanced, which has reporting
services. IIS is installed. I'm configuring the Report Manager Virtual
Directory Settings part of the "Configure Report Server". This is a 2 part
question:
1. After configuring the Report Manager Virtual Directory, the icon remains
...
|
Extract Attribute across many XML docs
Tue, 26 Feb 2008 10:33:01 -0800
I want to extract the value of the CorrelationID without having to specify
the entire path. There will be over 50 different XML documents with
this attribute and I would like to avoid a large number of statements to get
this value.
declare @MessageBody xml
,@CorrelationID bigint
select @Mes ...
|
XML data type in distributed environment
Mon, 25 Feb 2008 10:08:58 -0800 (PST)
In SQL server 2005, distributed query is not supported if there is xml
type column in the table. I could use nvarchar in the table and create
view and cast it to xml to work around it. But how could I utilize the
xml schema? How to utilize XML index in such situation? Please help.
Thanks a lot.
George ...
|
Distributed Query: Import XML using OpenRowSet Bulk from UNC - access
denied
Mon, 25 Feb 2008 02:25:33 -0800 (PST)
I'm having issues importing XML data using a distributed query with
the following statement which is run from an XP workstation named A
connecting to SQL2005 Server B, the data is located on a server C at
the following UNC path \\SERERC\SHARE\PATH\DATAFILE.XML
DECLARE @xml XML
SELECT @xml =CONVERT(XML, bulkc ...
|
Extract and Insert Xml nodes
Thu, 21 Feb 2008 11:48:19 -0800 (PST)
In SQL Server, how would you extract:
<member member_id="3" />
<member member_id="4" />
from a sql column of type xml with value:
<group group_id="1">
<member member_id="2" />
<member member_id="3" />
<member member_id="4" />
<member member_id="5" />
</group>
and insert (the above extraction) into ...
|
|
|
querying an XML string in SQL Server
Thu, 21 Feb 2008 08:33:55 -0800 (PST)
I need to query an XML string in SQL Server, and pull a couple of
elements as columns in the query result. read an excellent article on
the subject of xquery (http://weblogs.asp.net/jgalloway/archive/
2007/02/16/passing-lists-to-sql-server-2005-with-xml-parameters.aspx).
I was able to get this to work after som ...
|
xml nodes and user defined function
Thu, 14 Feb 2008 11:58:13 -0800 (PST)
Here is the script:
create table test(id int identity(1,1), doc varchar(max))
create view dbo.[doc]
as
select id,
col.value('(./last_name)[1]','varchar(200)') as [Last Name],
col.value('(./first_name)[1]','varchar(200)') as [First Name]
from [test] u
cross apply (cast (doc as xml)).nodes('people/person') a ...
|
Our new website
Fri, 8 Feb 2008 15:33:27 -0800
This website is for artist, freelancers, programmers, writers, translators. All who is looking for work.
If you are a skilled professional use page "Add profile" to create your profile.
Also this website is for those who is looking for skilled professional.
If you are looking for a professional use page "Pr ...
|
