:ermm: Have you tested Peso's/Peter's code that he sent you yet? His code normally...

SQLkiwi (5/6/2011)

---

WayneS (5/6/2011)

---

I know what you mean. I, for one, am looking forward to the revealing of the ultimate DelimitedSplit function....

GilaMonster (5/7/2011)

---

Jeff Moden (5/7/2011)

---

You can only say that once. I don't know if you had anything to do with it but...

This will load the information into a temp table on your system, and show you which procedures are in which SSIS packages.

-- declare and initialize variables for this script.

DECLARE @path...

bvaljalo-1000038 (5/5/2011)

---

Thanks Wayne.

That sounds like a great solution.

Is there any way I could trouble you to expound a bit upon this methodology? I've used Bulk Import in procedures that...

peter-757102 (5/6/2011)

---

WayneS (5/6/2011)

---

Can we get someone to put Peter's and Nadrek's code into a new test script, so that all can easily test it? Just modify Jeff's script to remove...

I know what you mean. I, for one, am looking forward to the revealing of the ultimate DelimitedSplit function. It would...

peter-757102 (5/6/2011)

---

Nadrek (5/6/2011)

---

Peter: On my machine, you've definitely beat the article's original try, and beat my Union version, but the 0 based permanent temp table is still better.

Wayne: thank you...

Brandie Tarvin (5/6/2011)

---

Whoot! Did I mention I just got another story accepted? "The Hunt for Liberty Jones," my second science fiction story. And yesterday, I received the edits request.

Editor's Note:

---

...

Nadrek (5/6/2011)

---

peter-757102 (5/6/2011)

---

New graphs would be nice, I got the feeling that the on-the-fly generated tally is now just as fast, if not faster then a 0 based physical tally...

I see three things that can be involved in the slow performance:

1. Cursors...

Check out the link in my signature on cross-tab and pivot tables.

cgrammont (5/5/2011)

---

Yep.

cgrammont (5/4/2011)

---

Version control for application code (VB, CSharp, etc) I know. But version control for SQL, not really sure how to approach it, much less what to use for...

ISNULL(upper(VCTYCLB), '')

Have you looked here[/url]?