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 181
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 323
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 171
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),...
Gambero
11-26-2008 03:40 PM
Gambero Go to last post
24 330
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 283
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...
Julie
11-20-2008 01:12 PM
Julie Go to last post
48 345
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 153
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...
dnandhak
11-17-2008 01:38 PM
Bob Go to last post
24 408
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...
shwac
11-14-2008 12:28 PM
Martin Honnen Go to last post
12 170
Dear SQLXML specialists and other animals, I got the following SP, that runs a SQL statement with FOR XML EXPLICIT: **** SQL STATEMENT...
ali.koyuncu@gmail.com
11-13-2008 03:10 PM
Doug Lubey Go to last post
21 488
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...
jojo123
11-10-2008 06:13 AM
jojo123 Go to last post
23 229
Where do you download the adventureworks2008 databases?
Andy B
11-10-2008 02:15 AM
Joe Fawcett Go to last post
12 172
Hi all..Martin helpĀ“s me to do this query WITH XMLNAMESPACES (DEFAULT 'http://schemas.microsoft.com/powershell/2004/04') SELECT...
LPJ
11-07-2008 09:16 AM
LPJ Go to last post
106 744
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...
kpb
11-07-2008 04:12 AM
Bob Beauchemin Go to last post
11 121
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"...
LPJ
11-06-2008 12:31 PM
LPJ Go to last post
66 439
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...
ajtaylor@hushmail.com
11-04-2008 06:10 AM
Bob Go to last post
33 351
Hi, Is there any sql query available to convert the table data or table structure into xml file for sql 2005? Thanks, Sony
sony.m.2007@googlemail.com
11-04-2008 04: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 04:37 AM
Bob Go to last post
11 129
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 168
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 487
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 169
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...
SammyBar
10-22-2008 04:47 AM
Joe Fawcett Go to last post
11 265
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 523
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"...
FrankyDM
10-20-2008 12:35 PM
FrankyDM Go to last post
11 231
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...
Hillbilly
10-18-2008 04:04 PM
Hillbilly Go to last post
22 304
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 267
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 262
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...
Simon
10-16-2008 07:55 AM
Simon Go to last post
11 134
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 525
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 854
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...
farshad
10-13-2008 06:48 AM
Martin Honnen Go to last post
11 136
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 258
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 379
Why doesn't this work? DECLARE @x XML SELECT @x = ' <OnlineResponse xmlns="http://www.myURL.com/schema/online" version="1.0" message="Valid...
NancyDotCom
10-02-2008 12:33 AM
Jacob Sebastian Go to last post
22 220
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...
kevin@teamstephens.com
10-01-2008 09:14 AM
kevin@teamstephens.com Go to last post
44 280
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 150
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...
Bjorn
09-25-2008 02:51 AM
Bjorn Go to last post
22 209
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...
raj
09-24-2008 02:20 AM
Jacob Sebastian Go to last post
11 307
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 421
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...
raj
09-17-2008 07:38 AM
Pawel Potasinski Go to last post
11 133
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...
SammyBar
09-15-2008 07:10 PM
SammyBar Go to last post
22 157
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...
byteman
09-13-2008 10:19 AM
Michael Coles Go to last post
55 472
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...
Farmer
09-11-2008 01:09 PM
Farmer Go to last post
22 256
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 415
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 455
"Travis McGee" <travisGatesMcGee (AT) hotmail (DOT) com> wrote
Travis McGee
09-05-2008 07:21 AM
Bob Go to last post
78 612
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 298
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 285
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...
byteman
09-02-2008 05: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...
micmixx@gmail.com
09-01-2008 04:46 AM
Bob Go to last post
11 241
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.