Viewing 15 posts - 54,526 through 54,540 (of 59,067 total)
How many times Government changed calendar in last 20 years?
Heh... here in the States, ya just don't know... look what they've done to DST, Primary days, and the...
October 18, 2007 at 9:01 pm
Matt Miller (10/18/2007)
I don't have a HUGE database on hand with relevant data, but on 50K records...maybe a second.
Thanks, Matt. Like I've said so many times, I don't have...
October 18, 2007 at 8:55 pm
Now we try to elevate ourselves to Jeffs' level
Heh... nah... it's not worth all the nosebleeds due to lack of Oxygen 😀
October 18, 2007 at 8:48 pm
joe joe (10/17/2007)
Hi Jeff,I looked into the ZP4, and truely looks very handy. But I don't have any adresses in USA, only in Europe.
But thanks for the tip 🙂
Ack... my...
October 18, 2007 at 8:47 pm
Luis,
How many rows do you end up with in your result set?
October 18, 2007 at 8:15 pm
Now, that looks like a good use for a CLR... how's the performance? (I can't test it... don't have 2k5 available)...
October 18, 2007 at 7:57 pm
Sounds like a pretty good plan... GUI is the place where such formatting should occur.
October 18, 2007 at 7:52 pm
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...
October 18, 2007 at 5:48 pm
mrpolecat (10/18/2007)
declare @startdate datetime, @days int
set @startdate = '1/1/2007'
set...
October 18, 2007 at 5:44 pm
Derek Karpinski (10/18/2007)
October 18, 2007 at 5:31 pm
"Sister" table for the normally null columns... proper normalization of the table would be better.
October 18, 2007 at 4:46 pm
Most of us get pretty ticked off about people that multipost...
October 18, 2007 at 4:36 pm
So... add a CASE to the calculated column and you're done!
October 18, 2007 at 4:28 pm
Partitioned view might be a possibility...
October 18, 2007 at 4:25 pm
Viewing 15 posts - 54,526 through 54,540 (of 59,067 total)