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     
Document Recovery for SharePoint http://t.co/NNVEnlKWK2 Day Organizer http://t.co/ptC4M6Q1iv ALTools Halloween Wallpaper 2k6 http://t.co/5ivwRdGGw4...
Godwin Horatiu Holywell
04-01-2013 02:33 PM
Godwin Horatiu Holywell Go to last post
0 64
Hi guys: select experience.query(N'/root/experience') from UsersProperties the code above works, but I want to use parameter to substitue...
shawn
11-05-2012 06:27 AM
deepak.kavi2010@gmail.com Go to last post
12 355
Hi Let say I have the table of 2 fields, Project >> VCHAR2 XML >> XMLtype (containing XML data) In my XML field record 1, I have <Project ID='P01',...
punyavee napalai
02-02-2012 05:31 AM
punyavee napalai Go to last post
0 605
I need to return a single row for each 'asset' with the parentId taken from the details node. This is what I have so far DECLARE @myXml AS XML SET...
Ken Cowley
12-07-2011 07:54 AM
Ken Cowley Go to last post
0 136
I have a small web application in (created in VS2010) that connects to a sql server and provides the user with information like first name, last name...
Spero
09-05-2011 11:15 AM
Spero Go to last post
0 117
I'm trying to import a single xml file into a single SQL 2008 R2 table using SSIS. The xml file has many elements so SSIS wants to put them into...
poorman
05-13-2011 12:11 PM
poorman Go to last post
0 117
Hi In the follwing query, I use a very bad way to compute the last field (Position) using 1 + (ROW_NUMBER() OVER (ORDER BY att) - 1) /3 as...
pi
05-02-2011 12:32 PM
pi Go to last post
0 109
I'm totally new to working with XML and I'm having trouble with what I believe to be a simple task. Daily I receive multiple files that contain xml...
Charles Sands
04-18-2011 08:17 AM
pi Go to last post
1 112
I've recently begun receiving xml files and ran into a small problem that seems syntax related, but I simply can't find where it is. Below is the...
Dan
04-05-2011 02:20 AM
Erland Sommarskog Go to last post
1 95
VTD-XML 2.10 is now released in Java, C#, C and C++. It can be downloaded...
dontcare
02-28-2011 07:59 PM
dontcare Go to last post
0 114
I have id and xml columns in mytable. I want to update an element called myelement with the following UPDATE MyTable SET xml.modify ('replace value...
Roy
10-21-2010 04:51 AM
Michael Jones Go to last post
78 776
I may have posted this in the wrong group. I have built a VB application that reads values from SQL server and uses one of the selected values to...
Spero
09-15-2010 07:23 PM
Spero Go to last post
0 110
What is Happening? This message is to inform you that Microsoft will soon begin discontinuing newsgroups and transitioning users to Microsoft...
nntp@microsoft.com
09-11-2010 09:56 AM
nntp@microsoft.com Go to last post
0 111
I thought this should be simple but it does not seem to work. I was trying to use FOR XML to generate XML data and XSD and SQLXMLBULKLOADLib to...
EPK
09-01-2010 06:20 AM
Aaron Dicks Go to last post
4 219
Mitchell_Collen via SQLMonster.com wrote: The argument to the nodes method should be a path expression like e.g. '/blocked-process-report'. Your...
Martin Honnen
08-31-2010 08:08 AM
Mitchell_Collen via SQLMonster.com Go to last post
1 113
I have never done this before and do not know where to start. Do you know how to parse out this TextData column into a readable string showing only...
Mitchell_Collen via SQLMonster.com
08-21-2010 08:20 AM
Martin Honnen Go to last post
1 99
I have something like the following: declare @msg xml set @msg = '<Message><SubItem>Some Text</SubItem></Message>' I'd like to be able to extract...
Charles
08-04-2010 07:59 AM
Charles Go to last post
4 100
I need to use XQuery to move a node between two XML data type fields... I know I can delete a node like this: SET...
Derek Hart
07-22-2010 07:33 PM
Derek Hart Go to last post
2 101
This will give me a single line with a list of MyText attributes, recursively, under the...
Derek Hart
07-21-2010 12:12 PM
Martin Honnen Go to last post
5 103
Hi, SQL 2005 encodes special characters like & as &amp; when outputting XML. Is there a way to get it to html encode all special characters, for...
£Jim
07-20-2010 03:12 PM
£Jim Go to last post
0 104
Using SQL Server 2008 XML Data Type For A Column How can I recursively count all the nodes within a node... I have a node that is simply ...
Derek Hart
07-19-2010 12:31 PM
Derek Hart Go to last post
2 114
Mary wrote: I am sure I suggested to use the 'Load' method, not the 'LoadXML' method. Also note that that suggestion is only possible if you use...
Martin Honnen
06-17-2010 01:29 PM
Mary Go to last post
2 1,207
SQL Server 2008 (not r2) I am trying to get the Attribute values "TestAccount1" and "TestAccount2" from the below XML. I can't seem to get the...
SnapDive
06-14-2010 06:50 AM
Martin Honnen Go to last post
1 285
XML Fragment @XMLData XML <table numcols="9" tag="TEST_TBL"> <Group fmt="center"> <data tag="ProductId"> <string>1234</string> </data> <data...
RJ Roberts
05-27-2010 04:20 PM
Bob Go to last post
1 385
Hello, The following is my XML data &lt;specification&gt; &lt;item name=&quot;bore&quot; measure=&quot;mm&quot;&gt;96&lt;/item&gt; &lt;item...
bala
05-27-2010 10:20 AM
bala Go to last post
0 257
I have two tables like this declare @Habits_new table(ID int,Habits xml default '<habits></habits>') declare @Habits_OLD table (ID...
Mukesh
05-12-2010 09:35 AM
bking Go to last post
1 354
Date 5/4/2010 Starting in early summer 2010, Microsoft will begin progressively closing down the Microsoft public newsgroups to enrich conversations...
05-07-2010 04:50 AM
Go to last post
0 270
Hi, we are having some performance issues regarding xml shredding. At this point we are extracting data from xmls from nearly 60...
Johnny Persson
04-29-2010 01:26 PM
scmike Go to last post
6 553
Hi All, I have an XML that has a layout as follows: <books> <book id='12' name='test1'> <authors> <author id='1' name = 'jill' /> <author id='2'...
Ben
04-20-2010 12:59 PM
Ben Go to last post
2 359
hie friends..how to deploy web application in globus toolkit i mean to say how can we convert web service to a grid service??
Rohith Kumar
03-29-2010 01:44 AM
Rohith Kumar Go to last post
0 291
THANK YOU FOR YOUR HELP. --From this XML declare @xml xml = '<root> <Identity docID="F230D2AA-BD00-4B68-BDDC-394F900AE583"...
Farmer
03-24-2010 02:37 PM
Farmer Go to last post
0 306
Hi, I am having an issue with the ordering of my xml tags. Please see my example below: SELECT 1 as Tag, 0 as Parent, NULL as , NULL as , NULL as...
Benzine
03-04-2010 05:02 AM
Bob Go to last post
7 586
hi all. I need to save the mass information from an xml in sql database from c # is not how. thanks -- desarrollo
paulcc84
03-03-2010 02:06 PM
Stefan Hoffmann Go to last post
1 478
In a Asp.Net 3.5 application I need to read this XML chunk, inside a Stored Procedure (sql Server 2008): declare @xml varchar set @Xml...
Alberto
02-25-2010 07:47 AM
Alberto Vitiello Go to last post
2 547
hi, in SQL Server 2008, I am trying to create a XML SCHEMA COLLECTION for the following xml, but I am getting the error Msg 2378, Level 16, State...
NMahmoud
02-19-2010 10:24 PM
jacobsebastian Go to last post
5 611
I am creating an xml blob out of concatenated string data successfully in sql server 2008. I have been asked to now append results from another...
Carl Henthorn
02-10-2010 04:54 AM
Bob Go to last post
1 627
Nuevo Modelo R4i para Comprar R4i para nintendo Ds, Ds Lite , Dsi y Dsi...
tesddalws
02-08-2010 12:06 PM
tesddalws Go to last post
0 465
We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on the...
Mia
02-08-2010 10:28 AM
Mia Go to last post
0 286
Many problems with performance and safety of your computer can be solved easily with an updated antivirus and recognized. Antivirus Free...
antivirus gratis
01-26-2010 03:09 PM
antivirus gratis Go to last post
0 275
I have Windows Vista home premium. I recently installed a WNDR3300 NETGEAR router. Since then, I cannot open certain software programmes. I get...
Chalfont
01-12-2010 03:28 AM
Chalfont Go to last post
0 359
Hi I'm trying to build an XML document from a relational schema. A lot of it works well, but I've having trouble building sub-elements which have...
Chloe C
12-29-2009 08:08 AM
Chloe C Go to last post
2 378
Hi - I'm trying to parse the google analytics xml file returned from my data query. Under the item node, there are two tags - dxp:dimension and...
chris
12-18-2009 05:46 AM
Bob Go to last post
2 397
Hello, In one database in my company. Previously the data in SQL Server, the tables were simple text and number formats and it was easy for me to...
SVCitian
12-14-2009 01:02 AM
Stefan Hoffmann Go to last post
1 379
has anyone noticed any performance benefits from changing FOR XML EXPLICIT SELECTs to FOR XML PATH(...) SELECTs? I have some large EXPLICIT SELECTs...
Dan Holmes
11-30-2009 09:51 AM
Bob Go to last post
1 343
Hi, I have an XML column in a table and i need to fetch the record based on some values, that are part of the XML as nodes. The xml format looks like...
Pavan
11-30-2009 06:32 AM
Pavan Go to last post
6 343
Hi All, I have an input XML which needs to make an inner join with table on a specific field. I could not find the correct sysntax to do that. Here...
Ben
11-27-2009 03:35 AM
Lakhan Pal Garg Go to last post
6 425
I'm beginning to learn XML with SQLServer. If SQLXML delivered the features in SQLServer 2000 and if it is deprecated in SQLServer 2005/2008...
rgn
11-25-2009 06:48 PM
Bob Beauchemin Go to last post
5 463
Hi, I have a problem regarding inline selecting the right nodes from a tree. I would really like to write my statement like the...
Niels
11-19-2009 08:04 AM
Niels Go to last post
2 334
We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on...
Mia
11-18-2009 09:30 AM
Mia Go to last post
0 306
<SampleXML> <Tables> <Table value="abc" /> <Table value="123" /> </Tables> <Fields> <Field value="Name" /> <Field value="Price"...
Anonymous
11-16-2009 05:26 AM
Bob Go to last post
2 393
Post New Thread

Display Options
Showing threads 1 to 50 of 3392
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 - 2013, Jelsoft Enterprises Ltd.