How do I lose the exponential display in Query Analyzer?

I have a SQL Server 2000 database with a table with a
field defined as simply [float]. I inserted several
values into the table for this field such as 0.0024.
My question is that when I query the table as follows:
select rcf from tableX
I get such values as 2.3999999999999998E-3. Is there
any reason why SQL Server simply does not display
0.0024? How can I prevent exponential display? Thanks!
GusFloat is an approximate data type and some values cannot be precisely
stored. QA is showing the actual value stored in the database. You can
cast the value to an exact type for display purposes:
DECLARE @.x float
SET @.x = 0.0024
SELECT @.x
SELECT CAST(@.x AS decimal(10,4))
See 'Approximate numeric data' in the SQL Server 2000 Books Online
<createdb.chm::/cm_8_des_04_82ic.htm> for more information.
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"Gus" <gcoll@.yahoo.com> wrote in message
news:be7512a6.0309241846.4892c7ff@.posting.google.com...
> I have a SQL Server 2000 database with a table with a
> field defined as simply [float]. I inserted several
> values into the table for this field such as 0.0024.
> My question is that when I query the table as follows:
> select rcf from tableX
> I get such values as 2.3999999999999998E-3. Is there
> any reason why SQL Server simply does not display
> 0.0024? How can I prevent exponential display? Thanks!
> Gus

HOW Do I GET DATA ANALYZER TO CONNECT TO MY SSAS 2005 DB's EXTERNALLY?

okay,

I have the SSAS 2005 cubes migrated. I have loaded MS Data Analyzer (the client ad-hoc quesry tool of choice for the CXX's and SSAS 2005) and can connect with no problem LOCALLY on the DA- installed on local machine. I have no lucky externally. I keep getting the error: Cannot connect to the "MYDBSERVER". The server is either not started ot too busy. HELP!!

kj

There coupld be multiple things going on.

1. You are missing new AS 9 OLEDB provider. Download and install Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider from http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

2. Your firewall might be blocking AS TCP port. Open port 2383 for default instance of AS.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.