| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi,
We have a poorly running xslt that takes approx 10seconds to process
200 rows of data into an HTML table. The xml is a merger of two
different...
JimLad
|
07-11-2007 05:19 AM
Marc Gravell  | 4 | 80 |
| | | Hi,
We have a poorly running xslt that takes approx 10seconds to process
200 rows of data into an HTML table. The xml is a merger of two
different...
JimLad
|
07-11-2007 04:11 AM
JimLad | 0 | 78 |
| | | How to add some attributes when I use For Xml Path?
As I developed the sql statement using For Xml Path, the users now required
add new attributes...
ABC
|
07-11-2007 03:34 AM
markc600@hotmail.com | 2 | 105 |
| | | In my xml file I have an element called pointInTime which has 4 elements
associated with it.
Among these 4 fields, I need to map 1 field to one SQL...
Meenakshi
|
07-11-2007 12:40 AM
Meenakshi | 0 | 67 |
| | | Is there any (perhaps roundabout) mechanism for testing xml columns
for equality?
Specifically, as part of a bulk update (i.e. into a staging table...
Marc Gravell
|
07-10-2007 02:51 PM
Marc Gravell | 4 | 88 |
| | | Hello All,
I was wonderting what is the most efficient way to pass xml data from
a (.NET) client application to a stored procedure in SQL Server...
CD
|
07-10-2007 02:35 PM
CD | 0 | 70 |
| | | Hi,
I'm using BCP to export large tables of data to XML. The output XML matches
the DataSets in my code and my plan was to use the...
=?Utf-8?B?SGVhdGggS2VsbHk=?=
|
07-10-2007 12:36 PM
=?Utf-8?B?SGVhdGggS2VsbHk=?= | 0 | 107 |
| | | I read and tried many times, but I cannot successful build xml
my target xml as:
<Header>
<Body IsUpdate="Y">
<Name IsUpdate="Y">ABC...
ABC
|
07-10-2007 11:22 AM
Peter W. DeBetta | 2 | 100 |
| | | I am trying to upload an xml file into SQL database by writing a xsd and
using bulkload in VB.
While doing this, I find that the datatypes in SQL...
Meenakshi
|
07-10-2007 10:25 AM
Daniel Bass | 2 | 101 |
| | | In my xml file I have an element called pointInTime which has 4 elements
associated with it.
Among these 4 fields, I need to map 1 field to one SQL...
Meenakshi
|
07-10-2007 06:38 AM
Martin Honnen | 2 | 91 |
| | | I want to add some nodes into xml variable:
For example:
The original xml:
<PO>
<PONO>123</PONO>
<PODATE>07252007</PODATE>
<POCNAME>ABC...
ABC
|
07-10-2007 06:34 AM
Martin Honnen | 2 | 112 |
| | | My xml file has the tags in the below format.
say :
<country>
<city>
<st>
<no>5</no>
</st>
</city>
<village>
Meenakshi
|
07-09-2007 11:31 PM
Meenakshi | 8 | 80 |
| | | I assume from http://technet.microsoft.com/en-us/library/ms171948.aspx
that it is possible to have the server-side provider be an OLEDB provider
for...
ChrisHarrington
|
07-09-2007 09:43 PM
Roger Wolter[MSFT] | 6 | 104 |
| | | Under SQL 2000 i would like to convert and XML RAW output to text type
by using "convert" and/or insert the data into a table, is this
posible?
i.e....
Rod
|
07-09-2007 02:15 PM
Rod | 6 | 90 |
| | | In my xml file, I have (say) four tags within a parent tag.
In SQL, I have a table with 4 field.
Among 4 fields, 3 fields take data from xml file...
Meenakshi
|
07-09-2007 10:58 AM
Martin Honnen | 2 | 99 |
| | | All,
Subject : SQL Server 2005 SSIS Script Help - XML Secure Pull in to DB table
I was wondering if any of you could help me with something.....
I...
=?Utf-8?B?cm1zdGVybGluZw==?=
|
07-09-2007 04:42 AM
=?Utf-8?B?cm1zdGVybGluZw==?= | 0 | 96 |
| | | Source:
<row>
<col_a>5</col_a>
<col_b>7</col_b>
<col_c>9</col_c>
</row>
Target:
ABC
|
07-07-2007 06:49 AM
Martin Honnen | 2 | 96 |
| | | I am trying to upload data from my XML file to SQL database using xsd schema
file.
I am doing using the XML bulkload in VB.
The piece of code I have...
meena
|
07-07-2007 02:05 AM
Meenakshi | 8 | 108 |
| | | My xml file has got multiple tags.
(eg) The format is something this this :
<aaa>
<element1>
</element1>
<bbb>
<element2>
</element2>
<ccc>
Meenakshi
|
07-07-2007 02:00 AM
Meenakshi | 0 | 139 |
| | | This is the format of my xml file.
I have to upload this data into SQL...
meena
|
07-07-2007 12:24 AM
meena | 0 | 81 |
| | | I need to open a newly created xml doc (in the same format) each time
a new one is sent to our web service. I would like to use a stored
procedure...
KEN
|
07-06-2007 08:34 PM
Mike C# | 6 | 148 |
| | | I have the following XML:
<secparameters>
<secparameter parm_id="1">
<secrequiredchar char_id="11">
<seccharval...
meetze@gmail.com
|
07-06-2007 10:39 AM
Peter W. DeBetta | 4 | 115 |
| | | I have a parent-child relationship. I ran a bulk load to create parents and
children - ok.
Now I want to run another bulk load to add children to an...
ChrisHarrington
|
07-05-2007 07:24 AM
Daniel Bass | 2 | 104 |
| | | I have an xml document variable of the form
<parent someAttribut2="1">
<Child1>some data</Child1>
<Child2>some data</Child2>
</parent>
I need to...
=?Utf-8?B?RnJlZA==?=
|
07-04-2007 01:06 PM
Fred | 4 | 101 |
| | | How can I convert the xml as:
<row>
<a>1</a>
<b>2</b>
<c>3</c>
<d>4</d>
...
...
...
ABC
|
07-04-2007 03:30 AM
ABC | 0 | 109 |
| | | I have two simple xml as:
<row>
<a>1</a>
<b>3</b>
<c>5</c>
</row>
<row>
ABC
|
07-04-2007 01:08 AM
ABC | 6 | 100 |
| | | The LCD modem SMTP connection to a Ultra FPU, for opening a LCD submenu
firewall: over a application and from Netscape you know either never
debug a...
Gerard Scott
|
07-03-2007 03:42 PM
Gerard Scott | 0 | 126 |
| | | Checking Excecution Plans on Stored Procedures to Enhance the performance of
systems I have inherited.
Quite a few Procedures involve the use of...
=?Utf-8?B?U3RldmUgW0RCQS1UQ10=?=
|
07-03-2007 10:34 AM
=?Utf-8?B?U3RldmUgW0RCQS1UQ10=?= | 0 | 87 |
| | | Hello there
I have an xml file that i need to compare it to data on server. and i don't
have xlt file (which is the base of xml as far as i know)
I...
Roy Goldhammer
|
06-29-2007 07:01 AM
Martin Honnen | 2 | 94 |
 | | Hi there,
I would like to know the best way to handle Xml data stored on Oracle and
Sql Server 2005 using XQuery/XPath and AdoNet. Ideally, the C#...
Oriane
|
06-29-2007 03:06 AM
Oriane | 8 | 184 |
| | | 30 minutes ago i found out that i needed to check if a element existed
in one of our xml documents we store in the database. I thought it
should be...
Stuck
|
06-27-2007 10:44 AM
Stuck | 8 | 122 |
| | | Dear all
I have a diffgram:
<?xml version="1.0" standalone="yes"?>
<diffgr:diffgram...
thecolour
|
06-27-2007 05:47 AM
thecolour | 4 | 119 |
| | | Hi all!
I have a SQL Server 2005 table with a XML field containing documents with
the following structure:
<document>
<title>Trittico di San...
Marco Minerva
|
06-26-2007 07:45 AM
Marco Minerva | 4 | 126 |
| | | Can a sql server 2005 express stored procedure call a soap service? In
my case the soap service with the data I'd want to tap would be
installed on...
sandal
|
06-25-2007 10:36 AM
sandal | 10 | 210 |
| | | Hi all,
I have on my SQLExpress instance a bulk procedure to load one XML file in a
table.
I have the following error:
System.Xml.XmlException:...
=?Utf-8?B?VGF0b3BpdHRh?=
|
06-25-2007 10:34 AM
Martin Honnen | 6 | 95 |
| | | I am new creating schemas, so i need litle help.
I have and xml archive, and i ned to create and schema por import the dato
to SQL Server 2000, but...
=?Utf-8?B?SnVuaW9y?=
|
06-22-2007 09:13 AM
=?Utf-8?B?SnVuaW9y?= | 8 | 119 |
| | | This is the content of one of the rows of the Message column.
<ERINOT VersionMajor="1"...
EŽ!k Visser
|
06-22-2007 02:01 AM
EŽ!k Visser | 18 | 170 |
| | | I need to bring the following data in an xml format (many more years
included) into the table listed at the bottom of this request.
This data is in... |
06-21-2007 09:37 PM
Adam Machanic | 2 | 134 |
| | | Hi!
Could somebody help me please.
I have a text that I download via XML from somebody's DB and I store it in
my SQL Server as ntext to preserve the...
Jenny
|
06-21-2007 03:58 PM
Michael Rys [MSFT] | 2 | 110 |
| | | I have an xml document with nested fragments, each with their own default
namespace. My xquery select statement fails because I can only declare...
Random
|
06-21-2007 11:02 AM
Martin Honnen | 2 | 150 |
| | | Hi, I hope someone can assist me with what appears to be a simple
thing - I'll try to explain with a very basic example of what I'm
trying to do. In...
dodds.matt@gmail.com
|
06-19-2007 05:27 PM
=?Utf-8?B?TW9uaWNhIEZyaW50dSBbTVNGVF0=?= | 2 | 114 |
| | | I am pulling my hair out over this issue. case is fine. the element is there,
etc... whats up?
XML Validation: Declaration not found for...
Trolane
|
06-19-2007 12:32 AM
Michael Rys [MSFT] | 25 | 413 |
| | | Hi,
Which is the Standard recommended in the utilization of xml by element or
attribute?
=?Utf-8?B?c3FsZXh0cmVtZQ==?=
|
06-19-2007 12:30 AM
Michael Rys [MSFT] | 4 | 135 |
| | | From what I've read, the new XML Data type does not preserve CDATA sections,
leaving FOR XML EXPLICIT the only option for returning CDATA.
I've...
=?Utf-8?B?TWFyaw==?=
|
06-19-2007 12:22 AM
Michael Rys [MSFT] | 8 | 151 |
| | | I use AJAX within an application to return XML query results from an
SQL 2000 database. Currently the application is housed on a webserver
that also...
clockemail@alltel.net
|
06-19-2007 12:20 AM
Michael Rys [MSFT] | 2 | 94 |
| | | We have the occasional issue with using XML data because of foreign character
sets
XML is passed to a stored procedure into a varchar(8000) data...
=?Utf-8?B?U3RldmUgW0RCQS1UQ10=?=
|
06-19-2007 12:18 AM
Michael Rys [MSFT] | 4 | 95 |
| | | Hello Everyone,
I am trying to extract data from from my Hit list and save as a file in XML
format.
I create a stored proc called it as...
=?Utf-8?B?Vml0byBDb3JsZW9uZQ==?=
|
06-19-2007 12:14 AM
Michael Rys [MSFT] | 2 | 137 |
| | | I am trying to determine whether we should use SQL Server 2005's XML
features to solve the following challenge. I appreciate any
suggestions or...
KW
|
06-19-2007 12:12 AM
Michael Rys [MSFT] | 2 | 96 |
| | | Is there a way to get SQL to return NULL field values as 'empty' XML tags,
instead of completely omitting them from the output?
I'm using FOR XML...
Michael L
|
06-18-2007 11:51 PM
Michael Rys [MSFT] | 6 | 142 |
| | | When I try to create a custom xml datatype I get the following error:
CREATE TYPE myOwnXMLType FROM xml;
Msg 15226, Level 16, State 1, Line...
=?Utf-8?B?QWxleCBWb2l0?=
|
06-18-2007 11:49 PM
Michael Rys [MSFT] | 4 | 84 |
