Steve T (11/11/2008)

---

Sounds like a bank/credit feed file. There's probably no data structure other than 2 columns. 1 for the header record you manually added and the other is probably...

Ggraber has the right idea... please see the following article for some of the potential pitfalls of concatenation...

http://www.sqlservercentral.com/articles/Test+Data/61572/

And, whatever you do, don't use recurrsion, cursors, or while loops to do...

Never heard of him... is he new?

They must've improved it a lot... I didn't like Toad because it kept croaking on me 😉

Patrick Russell (11/11/2008)

---

Thanks Jeff, I tried the restructured WHERE clause, and there is no noticable difference in the time. Removing the DISTINCT keyword still causes it to return duplicates.

It...

Yep... understood... with the lack of a clear understanding, I was just solving the original post on a larger scale.

Mohit (11/10/2008)

---

Thanks Jeff. I will play with this later today; if I may can I reference this work in the followup article? I plan to use this and...

Ed Klein (11/11/2008)

---

This is a little off the immediate article and a little theoretical, but it applies to the issue of RBAR in the aggregating function.

Why doesn't...

Glad it helped. Thanks for the...

Derek Dongray (11/10/2008)

---

Hi Jeef,

I just learned a function ... STUFF ... which solves the problem I was aware of relating to value chosen for the 3rd argument to SUBSTRING ......

Fine... answer my question... what specifically are you doing in...

Then I agree... bhovious' code would be the way that I'd go. Typically, cross-tabs like that are...

Thanks for the feedback... you sure you're all set?

Raghu Kurella (9/10/2008)

---

This is it man. Awesome. The first solution never finished after 7 min with 11000 records and this solution runs in less than "1" yes ONE second...

Thanks for...

I probably wouldn't do a lot of "IF's" although those can be quite effective provided that it's not building dynamic SQL. A well formed WHERE clause with CASE statements...