Ok, fine. If you don't want to take the trouble to tweak it, I guess I will. It is my code, I suppose, so who better?

Here is a slight tweak...

That's fine, use the values that match your server or DateName() instead. Remember, these routines were developed to meet in-house needs. They were...

Here are a couple of...

Just change float to decimal (or numeric). Internally, floats and doubles are maintained in an entirely different format from decimals and numerics. That's why you don't get...

I tried using "& nbsp;", as well as html tags such as <pre> (what I had been using). They are ignored.

Wait. Notice the space before the "nbsp;" above. The ampersand...

Ken,

How do you format the code in your post? I can't get this new forum tool to work for me.

It sounds like you have actual column "Fast", "Slow", etc. in different tables and you want a total count and summation from all those tables. Here, with just a few...

I doubt Microsoft will deprecate select * because, like it or not, it is part of the SQL standard. I agree with dots67's comparison between select * and goto. It...

Alpha or alpha-numeric keys are not significantly...

If you have a Number or Tally table, you can generate a list of time values very easily. My Tally table column is Num and the values start at 0....

Why do all the converting: char(10) to varchar(10) to datetime? And why lock yourself into a specific format? Let the system perform an implicit conversion...

Oh, sorry. :blush: I forgot to mention that it would seem to work because @Result is left at the correct answer from the method that came before it. So when...

Sorry, Jeff. You got the third method to operate a little faster by removing the setup just before entering the loop. This is a crucial step. Without it, the method...

Here's what I used:

-- Initialization common to both methods.

Declare @original decimal( 38, 12 ),

@Result decimal( 38, 0 ); ...

I answered that already. I defined my test table with a nullable datetime field. However, the OP seemed to be...