Yup... I know the feeling... you should see the one at work. Glad to help.

Dunno, maybe I missed something....

SELECT

 E.PAYTYPE

, SUM(CASE datepart(dw,E.TimeDate) WHEN 2 THEN E.Hours ELSE 0 END) as Monday

, SUM(CASE datepart(dw,E.TimeDate) WHEN 3 THEN E.Hours ELSE 0 END) as Tuesday

, SUM(CASE datepart(dw,E.TimeDate)...

It's a bit difficult to believe that you would ever have a NULL StartDate with a valid EndDate.  Normally, it's the other way around.  But, no worries...

For NULL StartDates, I...

Antares,

I apologize if the time lag between our posts caused this...

I had reposted a solution as follows...

STUFF(STUFF(REPLACE(STR(Run_Time,6),' ','0'),5,0,':'),3,0,':')

The original question was how to convert the Run_Time column of...

p.s.

If you are getting a "NULL' as a return, perhaps the code you wrote isn't actually finding what you think.  Post your code and we'll take a look.

Schalk and Antares,

I test this stuff before I post it and, you are incorrect.   STUFF works just fine on an INT values thanks to implicit conversions.  For example, this...

Autogrow = Fragmentation

As some have already said on this thread, set TempDB to be a reasonably large initial size and set autogrow to100 to 500 mb.  We currently have a...

Since the column is in the format of HHMMSS (even though it's a number),

For just a pure string representation of the time...

STUFF(STUFF(run_duration,5,0,':'),3,0,':')

For a real time as a...

You may experience some "wierd" answers when using FLOAT because it does it's math in a binary rather than decimal fashion.

The problem is most likely that the datatype in one of the columns is FLOAT which using binary math instead of Decimal math with some very unexpected results.  Recommend you...

I believe that your outer parenthesis are the problem.  Compare your script tot the previous answer.

> If you are using this for a one time query, you really will want to do it that way

... unless the return is very large in which case you'll...

There is if you update other fields along with the "cased" field.  Nulls will be put in the "cased" field.

Just to dispell some of the drum beating on this thread, I've asked 22 different SQL programmers and DBAs in some pretty large companies, some of which were related to...

First, Adam, thanks for the great link.  I took a look at ALL of the scripts including the additional reference to the auxiliary number table and I definitely see your...