Heh... what'cha gonna do with a CLR that can't be easily done with good performance in T-SQL anyway? 😀 Think of it as an "omen"...;)

Heh... thank you kindly for the "plug" 😀 Got a present for ya, MrPoleCat...

CREATE PROCEDURE dbo.AutoCrossTab

/**************************************************************************

Purpose:

-------

...

Went to the doctor and said "Doctor, when I hold my arm up like this (deomonstrating strange angle to arm), it hurts like hell". Doctor said, "Don't do that......

Not sure why you're trying to do such a simple thing in such a difficult manner... but, using YOUR code...

SELECT * FROM #TestTable

WHERE Title LIKE '%'+@dummy+'%'[/b] or Title is null

OR...

I think you'll find the problem in one of the text columns... you may have some trailing spaces in some of the descriptions. You can check for those by...

I'm thinking you haven't checked ALL possible solutions if you still have a problem...

Heh... can't believe you saved that list, Rudy 😀

Larger number of rows? Correlated aggragate sub-query on large number of rows? ...

Greg Snidow (10/19/2007)

---

Secondly, too all of you, I am amazed by how you guys can effictively do in a matter of hours, what it took me days, and sometimes weeks...

David.Poole (10/19/2007)

---

On the subject of delivering solutions I've seen too many solutions that were delivered on-time and on-budget that worked adequately at the time of installation but 6 months on...

Jack Corbett (10/19/2007)

---

Just a couple of comments.

I really enjoyed the thread. A lot of good information and no one got personal as I have seen happen when...

Matt Miller (10/19/2007)

---

Sergiy - you missed my response to Jeff. Short answer - on the same platform (hardware+table+indexes+data spead) - they tie, or at least are close enough to...

And, here's my "weekdays between dates" original post... just for reference 😀

http://www.sqlservercentral.com/articles/Advanced+Querying/calculatingworkdays/1660/

Part of what's so good about it is that it doesn't need to use a function... makes it very...

Ok everyone... pay very close attention... I'm going to say it again until you get it...

[font="Arial Black"]CLR's are for people who don't know T-SQL[/font]

First, Matt... thank you, Sir, for providing...

Ok... just ran Matt's code against the million row table... Ladies and Gentlemen, we have a tie! :w00t: Matt's function took the same amount of time as mine.

One thing...