Re: Weird Select Behavior

2004-08-05 Thread Curtis Stewart
uot; <[EMAIL PROTECTED]> To [EMAIL PROTECTED] cc Subject Re: Weird Select Behavior Easy!  With the first statement, you're converting physical_mb to TB (roughly, 1048576 is the "right" value), then adding them up.  For the 2nd one, you're conve

Re: Weird Select Behavior

2004-08-05 Thread Nicholas Cassimatis
cc Manager" <[EMAIL PROTECTED] Subject

Weird Select Behavior

2004-08-05 Thread Curtis Stewart
Hi everyone. I've been struggling with this for a time now and can't seem to come up with an answer on my own. I hope one of you might be able to explain it to me. When I run a simple sum select statement from the physical_mb field of the occupancy table I get one answer. However, when I run the s