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 07:18 AM
Bob Go to last post
24 236
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 07:01 AM
Lee Marks Go to last post
24 432
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 05:40 AM
Bob Go to last post
12 212
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 03:40 PM
Gambero Go to last post
24 389
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 07:03 AM
Joe Fawcett Go to last post
24 361
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 01:12 PM
Julie Go to last post
48 486
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 06:51 AM
Paul Hale Go to last post
12 192
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 01:38 PM
Bob Go to last post
24 504
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 12:28 PM
Martin Honnen Go to last post
12 213
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 03:10 PM
Doug Lubey Go to last post
21 601
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 06:13 AM
jojo123 Go to last post
23 310
Where do you download the adventureworks2008 databases?
Andy B
11-10-2008 02:15 AM
Joe Fawcett Go to last post
12 204
Hi all..Martin helpĀ“s me to do this query WITH XMLNAMESPACES (DEFAULT 'http://schemas.microsoft.com/powershell/2004/04') SELECT...
11-07-2008 09:16 AM
LPJ Go to last post
106 927
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 04:12 AM
Bob Beauchemin Go to last post
11 173
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 12:31 PM
LPJ Go to last post
66 583
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 06:10 AM
Bob Go to last post
33 441
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 04:46 AM
Bob Go to last post
11 168
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 04:37 AM
Bob Go to last post
11 174
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 04:28 AM
Bob Go to last post
22 215
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 02:16 AM
Joe Fawcett Go to last post
33 563
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-25-2008 11:42 PM
Travis McGee Go to last post
22 250
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 04:47 AM
Joe Fawcett Go to last post
11 299
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 03:36 PM
Paul Hale Go to last post
44 633
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 12:35 PM
FrankyDM Go to last post
11 258
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 04:04 PM
Hillbilly Go to last post
22 358
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 07:20 AM
Martin Honnen Go to last post
11 313
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 01:10 PM
Andy B Go to last post
44 407
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 07:55 AM
Simon Go to last post
11 180
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 09:17 AM
Martin Honnen Go to last post
55 656
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 02:57 PM
Susan Harris Go to last post
132 999
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 06:48 AM
Martin Honnen Go to last post
11 180
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 06:21 AM
Bob Go to last post
11 296
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 10:17 AM
Paul Hale Go to last post
44 476
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 12:33 AM
Jacob Sebastian Go to last post
22 283
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 09:14 AM
kevin@teamstephens.com Go to last post
44 381
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 08:03 AM
Andy B Go to last post
22 253
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 02:51 AM
Bjorn Go to last post
22 255
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 02:20 AM
Jacob Sebastian Go to last post
11 346
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 01:34 PM
Peder (DSP) Go to last post
22 487
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 07:38 AM
Pawel Potasinski Go to last post
11 175
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 07:10 PM
SammyBar Go to last post
22 224
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 10:19 AM
Michael Coles Go to last post
55 614
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 01:09 PM
Farmer Go to last post
22 325
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 09:01 AM
Leon Mayne Go to last post
33 489
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 06:31 AM
Bob Go to last post
66 589
"Travis McGee" <travisGatesMcGee (AT) hotmail (DOT) com> wrote
Travis McGee
09-05-2008 07:21 AM
Bob Go to last post
78 819
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 08:44 AM
Leon Mayne Go to last post
22 358
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 08:20 AM
Leon Mayne Go to last post
22 336
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 05:26 AM
Jacob Sebastian Go to last post
11 162
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 04:46 AM
Bob Go to last post
11 270
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 - 2015, Jelsoft Enterprises Ltd.