Viewing 15 posts - 17,686 through 17,700 (of 26,489 total)
But please remember, certification is not a replacement for hard earned experience.
January 4, 2010 at 2:56 pm
mannymendieta (1/4/2010)
Hi, I meant weekdays. Mon-Fri
Okay, so based on today (2010-01-04) what would the result of today - 2 be?
January 4, 2010 at 1:37 pm
CirquedeSQLeil (1/4/2010)
Lynn Pettis (1/4/2010)
Such was the Sage advice. :w00t:Should have seen that one Cumin :hehe:
That's Oregano! :hehe:
January 4, 2010 at 1:08 pm
What are business days? Based on today, was last Friday a business day?
The best way to accomplish this is by using a Calendar table that defines which days are...
January 4, 2010 at 12:54 pm
Also, when using BETWEEN you should know that the first value must be less than or equal to the second.
select
*
from
(select 0 as...
January 4, 2010 at 12:47 pm
ricky.chauvin (1/4/2010)
I tend to use these:Very useful!
Only issue I have with the subtracting of 3 milliseconds, it may work with the current datetime data type, but won't with the new...
January 4, 2010 at 7:46 am
Means just what it says, there was one occurance of an I/O request taking longer than fifteen seconds. The error occured on the secondary file in the error message.
What...
January 4, 2010 at 7:34 am
Viewing 15 posts - 17,686 through 17,700 (of 26,489 total)