The best scripts around are Ola Hallengren's, http://ola.hallengren.com.

😎

This is normally the kind of thing I do in such situation, that is using a snip to create the search code, paste the results into a new query and...

koolme_85 (7/22/2014)

---

Also Tried

DECLARE @TBLXML TABLE (COL1 XML NOT NULL);

INSERT INTO @TBLXML(COL1)

EXEC [dbo].[bofa_sp_esb_sel_acc]

@SearchType = N'A',

@SearchInputList = N'57575757',

@FAsInputList = null

Error :-

Msg 6819, Level 16, State 5, Procedure rj_sp_esb_sel_acc, Line...

Quick thought, look for the value "Actual" in any column of the tables and track it from there.

😎

That is the flawed/bugged version.

😎

You can query the table directly instead of using a variable, straight forward;-) Here is the same code as before with the difference of using an XML column in a...

mark26parks (7/22/2014)

---

I am using MS Access 2010 and one of my databases on our shared network does not open for any user. Shows "Unrecognized Database Format." error message.

I can't even...

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...