Jeff Moden (7/21/2014)

---

Evil Kraig F (7/21/2014)

---

mister.magoo (7/21/2014)

---

So is that right? You have a stored procedure that produces XML from data stored in tables and now you want to shred that...

First a correction, I was wrong earlier, OPENXML is NOT DEPRECIATED. My gray-cell memory playing tricks on me again, incorrectly recalled a note from Michael Coles book Pro SQL Server...

Quick...

koolme_85 (7/21/2014)

---

Thanks for the response Guys , i guess i was posting in an inappropriate thread.

i did try other methods but no luck

i guess i shall try posting in...

Lynn Pettis (7/21/2014)

---

Eirikur Eiriksson (7/21/2014)

---

Quick suggestion, don't use OPENXML, it is a depreciated feature and shoul not be used in new development. It is also much slower than XQuery/nodes methods,...

Quick suggestion, don't use OPENXML, it is a depreciated feature and shoul not be used in new development. It is also much slower than XQuery/nodes methods, there are many examples...

Here is a quick suggestion on how to use a blob table and views to parse the xml

😎

USE tempdb;

GO

/* Create the import table */

CREATE TABLE dbo.TBL_XML_DOC

( XML_DOC_ID INT IDENTITY(1,1)...

jbnv (7/20/2014)

---

Good for Mark that he can pull whatever hat is in the trendy bin, put it on and make a grand a day. I doubt, based on the description...

I must repeat Gail's advice, get an expert in to lead the effort. Only in the simplest of such situations would I even consider offering any advice via the forum,...

Of course you meant "at the most deep sql session":-D

😎

Must say, well worth it and good to meet you guys, enjoyed it!

😎

nills3nistelroy (7/19/2014)

---

I am using a A.mdb database. You know when connecting the databae Microsoft automatically create a .ldb file. Unfortunately my pc shutdown when connecting the database. As a resutl...

Must admit that I fear the same, almost like there is no comprehention what so ever.

😎

"When a freak hurricane swamps Los Angeles, nature's deadliest killer rules sea,...

Welsh Corgi (7/17/2014)

---

Why is it necessary to open a new session?[/quote

To make certain it works across sessions, logins etc.. The solution is no good if it doesn't

😎

Just a word of...