Viewing 15 posts - 56,341 through 56,355 (of 59,067 total)
Oh boy... you sure about that?
FLOAT is based on BINARY math which is also why it's so fast. The problem with Binary math is that you sometimes need more bits...
May 23, 2007 at 11:33 pm
<insert sound of applause here>
Heh... I absolutely agree on these types of posts and I used to get mad as hell at some of these folks... then it dawned on...
May 23, 2007 at 11:21 pm
Nicely done, Ed...
What I'd really like to know, though, in the original post, Janet said "I would like to call the function with my own datepart."...
My questions would be......
May 23, 2007 at 10:53 pm
Heh... must be because SQL Server couldn't easily read your code, either. ![]()
You need the outer join to be on the database table, not...
May 23, 2007 at 10:45 pm
| The same @Message will be sent every time, it won't change depending on the record. |
Ok... dunno about...
May 23, 2007 at 10:32 pm
It's always a golden plate... and a lot of it isn't available on the web until Serqiy puts it there... ![]()
May 23, 2007 at 10:29 pm
I don't have any websites I can direct you to, but here's a couple of my own...
May 23, 2007 at 10:21 pm
I'm pretty sure that when OSQL is used, any procs called by it are given the same spid. Of course, that's why testing is important.
Thanks for the heads-up...
May 23, 2007 at 7:27 pm
Heh... sorry Lynn... wasn't directed specifically at you... was a general comment. I agree with the idea of them allowing folks to "build comples queries incrementally".
The only thing I...
May 22, 2007 at 5:52 pm
Just a thought... How do you read sequentially from a table without a cursor or loop? Except for the occasional control loop on processes that handle thousands or millions of...
May 22, 2007 at 5:43 pm
Just out of curiosity, can someone who has SQL Server 2005 (unfortunately, I don't) tell me how long that bit of code takes to run? Thanks.
May 22, 2007 at 5:36 pm
Actually, I'm sorry... I normally don't turn things into a race. Just meant to show an alternative.
No matter what method you use, your article hits upon something that a...
May 22, 2007 at 7:20 am
Thanks for the feedback. Guess it's whatever you want. If today is a business day and the start date and end date are both today, I want it to register...
May 22, 2007 at 7:17 am
Just having a bunch of idexes may not help a thing...
Try these...
CREATE INDEX IX_Sales_Composite1 ON Sales (UserID,LineNumber,Amount) CREATE INDEX IX_Punctuation_Composite1 ON Punctuation (UserID,StartLineNumber,StopLineNumber,Dated)
May 22, 2007 at 6:25 am
Viewing 15 posts - 56,341 through 56,355 (of 59,067 total)