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

Heh... here in the States, ya just don't know... look what they've done to DST, Primary days, and the...

Thanks, Matt. Like I've said so many times, I don't have...

Heh... nah... it's not worth all the nosebleeds due to lack of Oxygen 😀

Ack... my...

Luis,

How many rows do you end up with in your result set?

Now, that looks like a good use for a CLR... how's the performance? (I can't test it... don't have 2k5 available)...

Sounds like a pretty good plan... GUI is the place where such formatting should occur.

sp_HelpFile

Matt... haven't tested it, but I agree... I think you've probably done it and it looks like the performance will outstripe any table solutions in this case... gonna have to...

mrpolecat (10/18/2007)

---

This works as well though it can only go 1 year out. Not sure about the perfomance with the self join.

declare @startdate datetime, @days int

set @startdate = '1/1/2007'

set...

Derek Karpinski (10/18/2007)

---

Absolutely... Us devs need SQL. And need to be flawless in it. And aware of any potential impact. I'd respectivally submit that nocount be set to...