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

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

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

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

The same @Message will be sent every time, it won't change depending on the record.

Ok... dunno about...

It's always a golden plate... and a lot of it isn't available on the web until Serqiy puts it there...

I don't have any websites I can direct you to, but here's a couple of my own...

1. Unless perfectly written parameterized code is used, there is no chance of a cached...

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

Than is impressive.  Thanks, Paul.

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

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

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.

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

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

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)