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...

First, nicely done, Matt! Yeah, if you don't include the start date as a Week Day, then you're correct... adding 30 Weekdays to '20070514' would, in fact, be 6/25...

Heh... now you've made a real mess of the formatting... :hehe:

Ooops... never mind... dunno what happened but it went back to a good format when I posted this message...

Matt Miller (10/18/2007)

---

Now it just got personal :). Amazing how some good ol' fashion testing seems to work better (I keep trying with not quite enough data to see...

Ah... sorry, it doesn't work as expected... it includes weekends which is what Greg is trying to exclude... in terms of your example, he wants to add 30 "week days"...