Lynn Pettis (7/7/2008)

---

Jeff,

Just one little problem with your code above. The closing paren for the CREATE TABLE #FileDetails is included in your comment. It took me a bit...

Steve Jones - Editor (7/7/2008)

---

It is interesting and the title doesn't help. It's a good thing that so many people want to help, and I can sympathize. Reading 50+ replies...

I don't know why folks say that CLR's perform better and are more scalable... it's absolutely not true in about 99% of the cases and several of us have beat...

You're right... it's an awesome study! Proves what I've been saying all along about some folks in the IT business... they don't look, they don't read, they don't understand......

Part of the problem is that you're not measuring time correctly... you're including the time it takes for Barry to build his example... I added a bit to Barry's existing...

Dang... thanks for the catch, Ken... I normally list that article and plumb forgot...

Marios Philippopoulos (7/7/2008)

---

2) Are you allowed to use sp_OA* procedures?

I don't know much about sp_OA* procedures, but I think they come with their own baggage of problems, and in any...

Ok, thanks for the feedback...

By the way... sorry I forgot to post the simple code example... just in case anyone else is interested...

DECLARE @SomeString VARCHAR(1000)

SET @SomeString...

Thanks,

Just a couple more questions...

1) Which date are you listing... Create, Modified, or Last Accessed?

2) Are you allowed to use sp_OA* procedures?

3) Do you really need the date and...

Ummm... maybe not directly, but you can...

Thanks for letting us know what the problem was, Jim... I think you're on the right track.

... and, here's a bit of simple code to play with...

If you cannot create a Tally table, please post back... we have other ways to skin the same cat. 🙂

MichaelC (7/7/2008)

---

the simple function that I was working on would simply parse a comma delimited string and return the requested section. For instance, I would pass a string, the...

Thanks for the feedback...

I avoid the use of cursors even in Oracle. Setbased methods work better there, too. 🙂

It would probably be better if you started a new thread... when you do, you might want to explain what kind of alteration you want to make to each stored...