You are summing and counting.  If you have multiple records where your CASE statement can be either 1 or 0, this may cause problems. 

You may want to do an...

No ideas on why this is displaying in this fashion for me?  It is rather perplexing...

I believe CASE assigns a value, while IF is flow control using equalities/in-equalities.  That may be why that does not work. 

(I'm sure you already know, GOTO can lead to...

I should have specified that I already went through all iterations, (e.g. 38,5 - 38,10 - 38,15 - etc.) of those settings.  I just posted my last attempt, not even thinking...

I cannot produce these results.  Maybe my settings are goofy. 

DECLARE @val varchar(200)

SET @val = '-3.16E-05'

SELECT CAST( CAST( @val AS float) AS decimal(38,37))

SELECT CONVERT(  decimal(38,37), CONVERT( float,...

Thanks Nicolas.  I understand those.  I misread the initial question and thought this was a date and not seperate fields for each part of a date.  That is why I...

I've written something that has this warning as well.  I only see the warning in Query Analyzer and it does not affect any application.  As with yours, I know mine will...

Can you break up your steps and return @@ERROR? 

BOL reference Access databases for this error.  It does mention you need to be the Admninistrator.  I am assuming you already...

I tried that too Lowell, but my setting in Query Analyzer yielded:  5/27/2005 12:18:47 PM. 

That is why I suggested a more, (shall we say) convoluted answer. 

This may not achieve what you want, but I am guessing this is for display reasons. 

SELECT CONVERT( varchar, CONVERT( datetime, '1/1/2005 09:00:00 AM'), 101) + ' ' +  CONVERT(...

I'm bad about remembering error coding when I try and answer a question quickly. 

Glad it helped. 

Thank you guys!  I was born with an extra thick skull, so it usually takes two or three hammers to get me to understand. 

BOL has return codes of 0 or 1.  I was messing with this and could not get it to work. 

CREATE TABLE #SpaceUsed( database_name varchar(200),

                                              database_size varchar(10),

                                              [unallocated...

Thanks Ron.  I had seen that, but it just wasn't specific enough for me as to whether it would make a difference in the results. 

---------------------------------------------------------------------------------

Frank, I had to use...

Thanks.  I figured that, but I could find no documentation.