You fail to ascertain that performance was not my primary design criterion. 😛

Understood. Thanks for taking the time.

I thought it was Bob and Ray.

Moving along now, Lynn.

Apologies to all for dragging this into the Thread. I should have let it go.

I resemble that remark, but having been involved for an...

Hey Paul, I revisited this and noticed that your last post replaced the cross apply of a VALUES clause with a subquery containing a lot of SELECT/UNION all statements. ...

You use the word "win" in an odd context, Gail.

Want to bet on crime statistics?

You gamble every day you LIVE in Memphis.

I agree with Howard. Do you require assistance in slowing it down?

'

Yeah, and my feelings are soooooo tender. :crying:

If I wanted to gamble on slots, Tunica is close enough.

I don't gamble a lot either, Jason, and my preferred game is actually poker for...

CirquedeSQLeil (9/23/2010)

---

The Dixie Flatline (9/23/2010)

---

CirquedeSQLeil (9/23/2010)

---

The Dixie Flatline (9/23/2010)

---

Any opinions on just getting rid of say 40% of the data? If you're trying to get a...

select *

from #t1

where item in (select item from #t1 group by item having COUNT(distinct value) > 1)

Talk about your low hanging fruit...

Mine could be just a bit longer.

CirquedeSQLeil (9/23/2010)

---

The Dixie Flatline (9/23/2010)

---

Any opinions on just getting rid of say 40% of the data? If you're trying to get a hundred rows out of...

Part of the problem is just knowing the terminology. Newbies have to phrase their objective without buzzwords or technical terms of art.

building a comma separated string (concatenate)

converting...