dbTalk Databases Forums  

Sponsored Links

microsoft.public.sqlserver.xml microsoft.public.sqlserver.xml

Discuss in the microsoft.public.sqlserver.xml forum.

Post New Thread
Threads in Forum : microsoft.public.sqlserver.xml Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
I have a SQL 2005 table that stores filenames with attached path. Could someone point me to a way to parse the path/filename into an XML...
Mike Stokan
12-05-2008 08:18 AM
Bob Go to last post
24 188
I'm having difficulty doing something that should be really simple. I need to be able to generate empty elements (eg. <tag/>) using FOR XML PATH. I...
Lee Marks
12-05-2008 08:01 AM
Lee Marks Go to last post
24 348
I am having problems getting a sum from xml. The following works and returns - 1150.75 DECLARE @Xml xml SELECT @Xml =...
Loren Dummer
12-03-2008 06:40 AM
Bob Go to last post
12 176
Hi, i have to "bulk" insert in my table some binary values (files) reading from xml text.. i use this way: create table test(MyKey varchar(32),...
11-26-2008 04:40 PM
Gambero Go to last post
24 344
Hello, I have a XML as below. As you may see, the ErrorMessage node has several "Error" nodes with attributes and data. Now, I want to get those...
Ganesh Muthuvelu
11-26-2008 08:03 AM
Joe Fawcett Go to last post
24 311
Hi, I need to get the name of the parent node and used "../@mp:localname" in the openxml statement. I got an error when trying to execute the...
11-20-2008 02:12 PM
Julie Go to last post
48 390
I would like to insert an XML fragment into multiple records as efficiently as possible. This SubQuery at the end returns a list of UserId's I...
Paul Hale
11-18-2008 07:51 AM
Paul Hale Go to last post
12 162
Hi, Is there a way to join nodes using for loop. for example i have <name> <alt>test1</alt> <alt>test2</alt> <alt>test3</alt> </name> here i want...
11-17-2008 02:38 PM
Bob Go to last post
24 437
Hi, In SQL Server 2005 SP2, when I use a query like this: SELECT f1, f2, f3 from myTable for xml auto, elements I always receive result on the...
11-14-2008 01:28 PM
Martin Honnen Go to last post
12 180
Dear SQLXML specialists and other animals, I got the following SP, that runs a SQL statement with FOR XML EXPLICIT: **** SQL STATEMENT...
11-13-2008 04:10 PM
Doug Lubey Go to last post
21 526
Hi I have the script below to read xml file into the database which works fine. I want to be able to read an xml file with any date and file id...
11-10-2008 07:13 AM
jojo123 Go to last post
23 244
Where do you download the adventureworks2008 databases?
Andy B
11-10-2008 03:15 AM
Joe Fawcett Go to last post
12 175
Hi all..Martin helpĀ“s me to do this query WITH XMLNAMESPACES (DEFAULT 'http://schemas.microsoft.com/powershell/2004/04') SELECT...
11-07-2008 10:16 AM
LPJ Go to last post
106 781
Type XML (Multi-page thread 1 2 )
I have the following tsql: -- TSQL START DECLARE @XSD varchar(MAX) SET @XSD = '<?xml version="1.0" encoding="utf-8" ?> <xs:schema...
11-07-2008 05:12 AM
Bob Beauchemin Go to last post
11 132
Hi all... I have this structure of xml in one column in my sql server table <Objs xmlns="http://schemas.microsoft.com/powershell/2004/04"...
11-06-2008 01:31 PM
LPJ Go to last post
66 483
Bit of a weird question (possibly) I have a sql server database that has amongst other things data locations (lat,longs) stored in degrees and...
11-04-2008 07:10 AM
Bob Go to last post
33 367
Hi, Is there any sql query available to convert the table data or table structure into xml file for sql 2005? Thanks, Sony
11-04-2008 05:46 AM
Bob Go to last post
11 143
Besides Books Online, what are the resources to study the fundamental of SQL Server XML feature? Is that necessary to study for basic XML course...
pedestrian via SQLMonster.com
11-04-2008 05:37 AM
Bob Go to last post
11 138
Hello all, A piece of software that was built for us by a 3rd party uses SQLXMLBULKLOADLib to import records from an XML feed into our database....
Sabrina Veksler
11-04-2008 05:28 AM
Bob Go to last post
22 181
I am making an announcement only mailing list service for the company website. I am trying to figure out if I should make a single table for...
Andy B
10-28-2008 03:16 AM
Joe Fawcett Go to last post
33 492
Have lots of xml files with data going into many many SQL tables, and the tables are not created. Also have xsd Schema files, but they are not...
Travis McGee
10-26-2008 12:42 AM
Travis McGee Go to last post
22 189
Hi all, I need to return Xml to the client via ODBC. At the back (Sql Server 2005) the executed query is Select @XmlData Where @XmlData is of the...
10-22-2008 05:47 AM
Joe Fawcett Go to last post
11 269
I would like to write a rich text messaging system. Basically, I have a WYSIWYG textbox component that allows users to format a message with...
Paul Hale
10-20-2008 04:36 PM
Paul Hale Go to last post
44 539
Sql Server 2008 Standard: To isolate the problem I'm having, I've created a simple Dbs with just one table, having an "int" field and an "xml"...
10-20-2008 01:35 PM
FrankyDM Go to last post
11 235
Have any best practices been learned to store (aggregate) RSS web feeds in the db? Shred or XML data type or what? Any design documents I might...
10-18-2008 05:04 PM
Hillbilly Go to last post
22 311
I have the following select/insert statement: insert into . select , from . where ... In the where clause, I need to use the value of the...
Andy B
10-18-2008 08:20 AM
Martin Honnen Go to last post
11 269
If I have a document fragment that looks like this: <Section ID= 1 Title="Section 1"> <Text> This is section 1. Put your own text...
Andy B
10-17-2008 02:10 PM
Andy B Go to last post
44 292
Hi guys, I have a VBScript file which is running on a server, pulling XML from a URL and creating an XML file. This file then needs to be imported...
10-16-2008 08:55 AM
Simon Go to last post
11 137
How do I replace an XML *fragment* in a document that's stored in an XML column? Let's say my database contains the following XML...
Susan Harris
10-14-2008 10:17 AM
Martin Honnen Go to last post
55 556
When I run the following query on an untyped document it works, but when I attach a schema ("@id" is of type xs:ID) the query fails because xs:ID...
Susan Harris
10-13-2008 03:57 PM
Susan Harris Go to last post
132 883
I am working on an xml file which has similar contents as below. Note that the issuer for each profile may be different. I can get all the values out...
10-13-2008 07:48 AM
Martin Honnen Go to last post
11 149
I see a lot of examples of adding schemas to the schema collection that start with: CREATE XML SCHEMA COLLECTION BookIndex AS N'<xs:schema...
Susan Harris
10-10-2008 07:21 AM
Bob Go to last post
11 261
Thanks very much for your response Jacob. Please forgive my lack of knowledge here but it looks like this would work fine when working with a single...
Paul Hale
10-09-2008 11:17 AM
Paul Hale Go to last post
44 392
Why doesn't this work? DECLARE @x XML SELECT @x = ' <OnlineResponse xmlns="http://www.myURL.com/schema/online" version="1.0" message="Valid...
10-02-2008 01:33 AM
Jacob Sebastian Go to last post
22 239
I have an XML column that contains multiple records and am looking for a way to get all of the values using a.value like query. Below is some TSQL...
10-01-2008 10:14 AM
kevin@teamstephens.com Go to last post
44 302
I have the following sql statement that is supposed to insert the xml into the xml column: insert into .(Article) values ('<NewsArticle Title="test...
Andy B
09-25-2008 09:03 AM
Andy B Go to last post
22 191
Hi, After taking a trace with SQL Server Profiler, it is possible to export the results of the trace to an XML file. Now I would like to write my...
09-25-2008 03:51 AM
Bjorn Go to last post
22 217
Hi, can anyone suggest me in doing the transformation from xml to xsl i have a column in my DB which is of xml datatype. for eg this is my xml...
09-24-2008 03:20 AM
Jacob Sebastian Go to last post
11 314
Hi Setting up a XMLA datapump in SQL2005 is well described in the "Configuring HTTP Access to SQL Server 2005 Analysis Services on Microsoft Windows...
Peder (DSP)
09-23-2008 02:34 PM
Peder (DSP) Go to last post
22 436
Hi, I have a XML stored in a column of datatype xml. i need to return the the xml on selecting the row . i am using java,jdbc for creating the...
09-17-2008 08:38 AM
Pawel Potasinski Go to last post
11 139
Hi all, I'm parsing an xml data type to import those data into a table. My current approach is: Declare @xDoc Xml Set @xDoc = some xml Set...
09-15-2008 08:10 PM
SammyBar Go to last post
22 176
Hi In our work we have a table with 37000 records (aprox). The table have a xml column, with primary xml index and a secondary path index. The xml...
09-13-2008 11:19 AM
Michael Coles Go to last post
55 502
Farmer, it's true that XSLT has no function to generate a GUID. If they are processing the transformation using .NET, there is support for embedding...
09-11-2008 02:09 PM
Farmer Go to last post
22 266
Hi again, I have a table which contains an XML column, and I have a stored procedure which returns records based on two columns, e.g. CREATE TABLE...
Leon Mayne
09-10-2008 10:01 AM
Leon Mayne Go to last post
33 424
I have two tables, one holding task details and the Id of the employee they are assigned to, and another table holding an XML representation of an...
Leon Mayne
09-08-2008 07:31 AM
Bob Go to last post
66 480
"Travis McGee" <travisGatesMcGee (AT) hotmail (DOT) com> wrote
Travis McGee
09-05-2008 08:21 AM
Bob Go to last post
78 664
I'm trying to do a simple 'replace value of' for an element in an XML column whose XSD looks like: <xs:element name="body" minOccurs="1"...
Leon Mayne
09-03-2008 09:44 AM
Leon Mayne Go to last post
22 314
Hello, I'm trying to update multiple nodes in an XML column in one update statement but am getting the error: Column name 'xmlEmail' appears more...
Leon Mayne
09-02-2008 09:20 AM
Leon Mayne Go to last post
22 302
I have a table with 37000 records with a int column and a xml column. The int column have primary index, the xml column have primary index, path...
09-02-2008 06:26 AM
Jacob Sebastian Go to last post
11 138
Hi, I'm storing some data into column X converting it to XML like: UPDATE xxx SET column_xml = (SELECT sth, sth2 FROM yyy WHERE {condition}). Now I...
09-01-2008 05:46 AM
Bob Go to last post
11 244
Post New Thread

Display Options
Showing threads 101 to 150 of 2635
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.