Viewing 15 posts - 56,221 through 56,235 (of 59,078 total)
Yeah, you're right... good catch and good eye
... nobody else caught that little boo-boo... ![]()
June 5, 2007 at 8:35 pm
Perfect. Thank you very much. That belays my previous suspicions about the new laptops. And thanks for taking it to the next couple of orders of magnitude! Always afraid to...
June 5, 2007 at 8:20 pm
By the way... if you want to know how JacekO's and my code works in some bit of detail, please refer to the following...
http://www.sqlservercentral.com/columnists/jmoden/calculatingworkdays.asp
June 5, 2007 at 7:56 pm
Thanks for the H/W info, Igor.
Do me a favor please... run the following code and let me know what times you get back? The reason I ask is because I'm...
June 5, 2007 at 7:43 pm
Hey folks...
Have seen lot's of different code and lot's of different opinions on this thread. I'd like first to congratulate Grant on producing an article that had such a tremendous...
June 5, 2007 at 7:06 pm
Thanks, Igor... my solution takes 8.6 seconds on my box first and all times. It's a little ol' P5 1.8 Ghz with 1 Gig of Ram and twin 80 Gig IDE hard-drives. ...
June 5, 2007 at 6:58 pm
Yep... Developer's Edition of SQL Server 2000 sp4. But, like you said, the evironment you run it in makes all the difference in the world for output speed. OSQL via...
June 5, 2007 at 6:50 pm
You're welcome...
I've verified that it's available in both SQL Server 2000 and 2005. Dunno if it will be available in 2008.
June 5, 2007 at 6:13 am
You can get a lot more than just the date...
EXEC Master.dbo.xp_GetFileDetails 'C:\AH.aspx'
June 4, 2007 at 5:31 pm
Just another way...
SELECT REPLACE(STR(somecol,6),' ','0')
June 4, 2007 at 5:19 pm
You know what they say... "Tuning makes perfect"
Keeps getting better and better...
June 4, 2007 at 6:12 am
Nicely done, Ian... didn't know the OP was doing the kind of stuff he said in a later post.
June 4, 2007 at 6:05 am
Heh... could be... the correct answer is "don't sort in a view".
June 4, 2007 at 6:03 am
Viewing 15 posts - 56,221 through 56,235 (of 59,078 total)