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

"Sister" table for the normally null columns... proper normalization of the table would be better.

Most of us get pretty ticked off about people that multipost...

http://www.sqlservercentral.com/Forums/Topic412362-5-1.aspx

So... add a CASE to the calculated column and you're done!

Partitioned view might be a possibility...