Ummmm.... sorry Matt... the function is not written correctly and it has not been called correctly. The function has two extra SET statements which slows it down and the...

Pierre... I think I like your attitude... alot!:)

Matt Miller (6/16/2008)

---

You can try that, but the...

Heh... cool... I finally beat Mr. Miller at a response... 😛

adi.cohen (6/16/2008)

---

Ohh... got me a litle confused..... I didn't notice I'm publishing in 2k forum, just saw this now (after you paid my attension to this).

I'm realy sorry for this...

Heh... I've found that it also works great on some developers 😀

Right up my alley... no need for...

Crud... Matt beat me to it... 🙂

rbarryyoung (6/16/2008)

---

Jeff Moden (6/16/2008)

---

rbarryyoung (6/16/2008)

---

Jeff Moden (6/15/2008)

---

rbarryyoung (6/15/2008)

---

On the other hand, if your sheets need to be resized based on the number of rows returned, then automated "Get External Data"...

rbarryyoung (6/16/2008)

---

Jeff Moden (6/15/2008)

---

rbarryyoung (6/15/2008)

---

On the other hand, if your sheets need to be resized based on the number of rows returned, then automated "Get External Data" refreshes can be...

Pierre Boucher (6/16/2008)

---

Just did some testing with a 300,000+ record table and following some advice from past post concerning cursor optimization, I was able to achieve the following stats:

CURSOR (LOCAL...

Thanks... now we're cooking... I'm on my way to work... I'll take a look at this tonight.

Hmmm... Glad this is SQL Server 2k5... makes it a lot easier to solve...

jcrawf02 (6/16/2008)

---

rbarryyoung (6/15/2008)

---

Are we thinking of the same thing? I thought the concatenation function...

That's more like it and that's part of what I'm talking about...

george sibbald (6/16/2008)

---

This is how the 'cheap' outsourcers (and some expensive consultancies I cannot mention) work. They tell you they can write your apps quicker and cheaper and it will...