I am trying to produce an XML doc from one table. I need to group(wrap) sections of the columns with parent tags. Here is an...

Rick

07-09-2003 08:54 AM
Rick

Ahh... So simple !! Thanks a lot guys !! "SQL Server Development Team " <sqldev (AT) microsoft (DOT) com> schreef in bericht...

Albert

07-09-2003 02:29 AM
Albert

Hi Tomas, I've forwarded your question to the product team, and I will get back to you with their response. Hope this helps, Michael...

Michael Brundage [MSFT]

07-08-2003 05:14 PM
Michael Brundage [MSFT]

In article <ey6kM#XRDHA.3236 (AT) TK2MSFTNGP10 (DOT) phx.gbl>, sqldev (AT) microsoft (DOT) com says... Yeah, been there - read that. Good reference...

Cam Penner

07-08-2003 02:57 PM
Cam Penner

Hi Harry, Are you using a managed application to create the Updategrams. If so then you will have to catch the SqlXmlException and print the...

Amar Nalla [MS]

07-08-2003 02:49 PM
Amar Nalla [MS]

Hi All, I am Pradeep, Using SQLXML BulkLoad to import wellformed xml to a simple table. How can i do that? can any one help me in this issue. xml...

Pradeep

07-08-2003 01:38 PM
Michael Brundage [MSFT]

I've been thrown a curve ball. I know how to load XML files that look something like this. <ENTITYLIST> <CUSTOMER> <Id>12345</Id> <ShortName>MY...

gofftim

07-08-2003 01:33 PM
SQL Server Development Team [MSFT]

Hi, I am getting an exception "The FOR XML clause is not allowed in a CURSOR statement." when i am trying to execute a simple select statement...

Ashwin Sugavanam

07-08-2003 08:33 AM
Ashwin Sugavanam

Hi, I am getting an exception "The FOR XML clause is not allowed in a CURSOR statement." when i am trying to execute a simple select...

asu1234

07-08-2003 08:26 AM
asu1234

Hi Matt, Can you send a sample SQL Script or some other info so that I can investigate. I am investigating a similar issue, please see...

SQL Server Development Team [MSFT]

07-07-2003 03:20 PM
Michael Brundage [MSFT]

If you're sure they have he same database and IIS security settings, my next guess would be file permissions. Make sure the files have the right...

Michael Brundage [MSFT]

07-07-2003 03:15 PM
Michael Brundage [MSFT]

Hi, I wud like to get an idea about how SQL Server 2000 and XML go hand in hand. I mean how and in what ways can an enterprise system...

Ricky_Singh

07-07-2003 03:10 PM
Michael Brundage [MSFT]

Hi, We are kind of discovery the whole setup here using Flash and firefly connecting to a SQL Server 2000 Through SQLXML via IIS 5.0 The Flash will...

Christian

07-07-2003 02:48 PM
Michael Brundage [MSFT]

I having a problem with an xsd annotated mapping schema in sql server 2000 using sqlxml 3.0 with the items in a sequence block in the schema...

Leeroy

07-07-2003 02:46 PM
Michael Brundage [MSFT]

Hi Raik, Unfortunately top 10 XML elements translates into an unknown number of SQL rows underneath (depends entirely on what your SQL data...

Michael Brundage [MSFT]

07-07-2003 02:33 PM
Michael Brundage [MSFT]

Hi Mark, This usually indicates a content-type issue. When XSL generates HTML output, it is required to emit a META tag which is not well-formed...

Michael Brundage [MSFT]

07-07-2003 02:28 PM
Michael Brundage [MSFT]

What I would like to do is to use a SELECT statement such as: SELECT * FROM mytable1 FOR XML RAW Then store the results in to a second table...

vbeer

07-07-2003 02:24 PM
vbeer

Hi Colin, Your column must contain a character that is not a valid XML character. Wrapping it with CDATA doesn't alleviate this problem. The only...

Michael Brundage [MSFT]

07-07-2003 01:46 PM
Michael Brundage [MSFT]

Hi Amar Nalla, It happens that I'm also having huge problems handling large XML docs, with lots of base64 encoded data. Do you know if the latest...

paulo_x

07-04-2003 12:25 PM
paulo_x

Interesting ... I also faced this problem sometime back but on a RC2 ... Not sure of the fix ... :( ... I also moved to a Win 2K server ... BTW can...

Vinodk

07-04-2003 11:24 AM
Randy

Hi, Whenever I join two tables using FOR XML AUTO, ELEMENTS I get a child element place holder in the result set whenever a parent doesn't have a...

Ned Radenovic

07-04-2003 07:52 AM
Ned Radenovic

I have the following SQL statement SELECT NAME_TXT, FROM Drivers FOR XML AUTO, ELEMENTS part of the data returned is the following:

Wayne

07-03-2003 10:08 PM
Wayne

Is there a stored procedure or other facility in sql server which allowes you to write in xml format to an os file? Thanks in advance

RG

07-03-2003 07:19 PM
RG

Let's say I run a query via HTTP that returns 100 gigabytes of data. The web server has 256 megs of RAM and 256 megs of virtual memory. Obviously,...

Terris Linenbach

07-03-2003 05:43 PM
Terris Linenbach

Has anyone had experience importing a position based file into SQL 2000? Basically, I know where each piece of data starts (its index) and where it...

Michael Baker

07-03-2003 01:08 PM
Michael Baker

Does anyone have any general tips for improving the performance of SQLXMLBulkLoad ? I find that when loading large numbers of small files (thousands...

Andy Mackie

07-03-2003 03:51 AM
Andy Mackie

Hi, I'm using SQLXMLOLEDB (SQLXML 3.0) to create XML data based on an annotated schema. When I try to execute the query, I get "Parent tag ID 2 is...

K. M. Kern

07-03-2003 02:32 AM
K. M. Kern

Hi! Is it possible to use updategrams on chain relationships? When I try I always get this message: <?MSSQLError HResult="0x80004005"...

Tomas Öberg

07-03-2003 01:41 AM
Tomas Öberg

Hi David, AFAIK the Biztalk Adapter uses Updategrams internally to send the XML updates to the SQL Server. Updategrams do not do any special decoding...

SQL Server Development Team [MSFT]

07-02-2003 12:51 PM
David Vins

Hello, I'm adding SOAP/XML update capabilities to an exisiting database with tables that use a 'bigint' identity column as a primary key. I'd like...

Randy

07-02-2003 12:20 PM
Randy

Hi Travis, If you want to put special characters like hyphen in the Updategram you will have to put around the field name or table name. Since...

SQL Server Development Team [MSFT]

07-01-2003 08:48 PM
Travis Neale

Hi, Everytime I try to run the vbscript provided by microsoft on our SQL 2K Server, I get the error "CustomerID was defined in the schema but is...

Levi

07-01-2003 08:42 PM
Levi Scharf

I am running into an issue with my xsd document that bulk loads an xml file into a sql database. The problem is I have an xml doc with...

Michael Baker

07-01-2003 01:45 PM
SQL Server Development Team [MSFT]

My "for xml" query could return half a gigabyte or more and I am looking for assurance that the client from which the query was initiated won't run...

Terris Linenbach

07-01-2003 01:32 PM
SQL Server Development Team [MSFT]

Hi Anthony, Performance issues are complex to troubleshoot on newsgroups. I would suggest that you open an incident with Microsoft Product Support...

Bill Cheng [MSFT]

07-01-2003 01:28 PM
SQL Server Development Team [MSFT]

Hi Ben, This works for me. I am using SQLXML 3.0 SP2 Beta 1. Which version of SQLXML are you using? Also your mapping schema reference in the...

SQL Server Development Team [MSFT]

07-01-2003 01:19 PM
SQL Server Development Team [MSFT]

I have a stored proc loads and parses an xml string using sp_xml_preparedocument and OPENXML. The stored proc has an input param of type ntext to...

Dan

07-01-2003 11:46 AM
Drew Seale

Hi, in my database I have a column where I store HTML formatted text. For querying the database I use a SELECT statement with the FOR XML AUTO,...

Raik Hoffmann

07-01-2003 11:32 AM
Drew Seale

Fair enough.. however for debugging, I need to execute the SPROC from QA. Therefore I need to use "test" XML against my SPROC. The real problem...

Ty

06-30-2003 12:17 PM
Ty

Got it working from your first example Mike. Thanks so much for the help! *** Sent via Developersdex http://www.developersdex.com *** Don't just...

Michael Baker

06-29-2003 11:28 PM
Michael Baker

Hi Anthony, Are you seeing this error only when AD is installed? If this is the case, then I am not sure what could be the reason behind it. I have...

Amar Nalla [MS]

06-29-2003 08:52 PM
Amar Nalla [MS]