Gus, you...

It's a handy function, and a well written article. But, although I much prefer CTEs to subqueries, recursive CTEs are notoriously slow for this type of problem. ...

Even a cross-tab is going to do an aggregation. I use MAX() as the aggregation function.

Any fool can write

Haiku in English.

All he does is stop at sev

I know 😉

But you could spend your time helping someone else who also needs it and would appreciate it.

Lynn,

He's a flamer. Just walk away. Unsubscribe from that thread, and let him take his attitude elsewhere.

Chad,

Thanks. 😉

I've always wondered about the sequence of titles. It seems like you should be crazy BEFORE you are committed. 😉

Lynn!! You're back !! 🙂

How was the desert?

Overwhelming relational angst?

Have a nice trek, Lynn. Mind the shai-hulud.

Did somebody say "googoo peanut clusters" ??

I was shocked to see renewed activity in this thread. I thought it was ancient history.

Don't worry, Stuart. There is no blacklist, and never...

Gail,

Try to... contain.... fist... of death!!

:w00t:

😛

If I may add a few comments:

1. Lutz knows SQL. He is humble enough to admit that he is still capable of learning more about it,...

Looks like pure spam to me. I'd vote to zap that account and remove all messages originating from it.