OK, I just want to confirm: are you on SQL Server 2000 or 2005?

For 2005 then CTE's like Lowell suggested are the way to go. For 2000 then change...

Ah OK. apperently they are really ZIP folders, sou you can just unzip them to a folder tree of XML files.

You know, the things is, I do not actually know how you get Execl into that XML format. The ".xslx" are not XML, the are compressed XML, and I...

It's an XML document. SQL Server 2005 has an XML datatype. So you just create a table with a column of the XML datatyoe and then load them...

Lowell (4/1/2009)

---

i'm still reading your code, but it looks like it is doing nothing more than getting a bunch of links for navigation recursively right?

i'd like to see the code...

Do you have the listing for "dbo.spA_ReadMenuLevels" also?

Thanks,

That's good...

Please note that I'm using Adobe Acrobat 6.0 Professional and PDF Printer is installed in my system and...

We are going to need the listings of those stored procedures that you are calling.

I don't think that you can do that.

You are in the wrong forum. This is a SQL Server 2005 forum.

Hmm, doesn't happen to me. Can you post an example that we can use to reproduce it?

Florian Reischl (4/1/2009)

---

"Run slower" sounds...

SQL Server Environments are not defined by SQL Server, they are defined by your organization and implemented on SQL Server.

Good job, Phil. For some reason I thought that SQL Replace() didn't rescan its replacements. Hmm, must be getting my languages mixed up. 🙁

As of SQL Server 2005 and later, the only time that you should use Cursors is when you actually want a procedure to run slower.