Copy data from one table Column another table Xml Node
Fri, 19 Mar 2010 05:49:01 -0700
I have two tables like this
declare @Habits_new table(ID int,Habits xml default '<habits></habits>')
declare @Habits_OLD table (ID varchar(50), Habit varchar(50))
Having data Like this
INSERT @Habits_new values(1,'<habits><habit>Drink</habit></habits>')
INSERT @Habits_new values(2,'<habi ...
|
Xml shredding performance
Sat, 06 Mar 2010 16:34:23 +0100
Hi,
we are having some performance issues regarding xml shredding.
At this point we are extracting data from xmls from nearly 60 different
companies - and therefore 60 different xml structures. The total amount
of xml is about 350MB and we are trying to extract the data as fast as
possible.
Our curren ...
|
Ordering of XML Incorrect
Tue, 2 Mar 2010 16:44:01 -0800
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 [ifti-draList!1!Item1!ELEMENT],
NULL as [ifti-draList!1!Item2!ELEMENT],
NULL as [Item1!2!Item1A!ELEMENT],
NULL as [Item1!2!Item1B!ELEMENT],
NULL as [Item2!3!Item2A!ELEMENT],
NUL ...
|
save the information from an xml in sql
Mon, 1 Mar 2010 11:51:01 -0800
hi all. I need to save the mass information from an xml in
sql database from c # is not how. thanks
--
desarrollo ...
|
marvendas@gmail.com Kit completo de Solenoides ( solenoid ) + chicote
Para Cambio automatico 01M hidramatico Audi A3 Vw Golf gti turbo 19002
Fri, 19 Feb 2010 19:24:39 -0800
Contato: marvendas@gmail.com
marvendas @ gmail.com
marvendas no gmail.com
Kit completo de solenoides para Volkswagem e Audi.
O kit contem:
5 solenoides
2 Epc ( solenoides de pressao )
1 Chicote
Serve para qualquer modelo VW ou Audi fabricados de 1995 ate hoje com o cambio automatico de 4 marchas ? 01M
Preço: ...
|
Error Code 0xc00ce562
Fri, 19 Feb 2010 14:46:48 +0100
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 =
'<Root><Foto><txtNomeFoto>150-1.jpg</txtNomeFoto><txtDescrizione>150-1</txtDescrizione><IdCategoria>1</IdCategoria><IdSc>1</IdSc><IdScSc>1</IdScSc><urlFotoPiccola>-Foto ...
|
How do I concat string and xml into xml output?
Wed, 3 Feb 2010 09:21:01 -0800
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 column that
is already XML data type to this same column. I figured I could just
concatenate the two data sources together and the two would just mesh. I keep
trippi ...
|
|
|
CREATE XML SCHEMA COLLECTION - Expected XML schema document Error
Wed, 27 Jan 2010 16:31:27 -0800
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 1, Line 23
Expected XML schema document
any idea how can I do that!
thank you
Nabila
declare
@xmlStr xml
set @xmlStr = '<?xml version="1.0" enco ...
|
error
Tue, 12 Jan 2010 01:28:01 -0800
I have Windows Vista home premium. I recently installed a WNDR3300 NETGEAR
router. Since then, I cannot open certain software programmes. I get two
messages. 1) MSXML is not correctly installed 2) path not correct. I have
tried to re-install MSXML but to no avail. As I have an OEM version of
Windows Vista, I ...
|
Attributes and elements in FOR XML subqueries
Tue, 29 Dec 2009 11:50:53 +0000
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 attributes as well as data. A simplified example is:
Tables
Name NameId Type
1 person
NamePart NameId Type Value
1 given Chloe
1 family Crowder
...
|
