Uncheck the following checkbox in QA: tools-->options-->connections-->"Use
regional settings..."

-----Original Message-----
From: Chip Smith [mailto:[Email Address Removed]
Sent: Tuesday, December 30, 2003 1:06 PM
To: LazyDBA.com Discussion
Subject: RE: Query Analyzer

Thanks, but this only returns 0.00.


-----Original Message-----
From: Santosh Tiwari [mailto:[Email Address Removed] Monday, December 29, 2003 9:33 PM
To: 'Chip Smith'; 'LazyDBA.com Discussion'
Subject: RE: Query Analyzer


this will give you the desired result:

select convert(numeric(20,20), 1/50)

Hope it helps

Santosh Tiwari
Project Manager

-----Original Message-----
From: Chip Smith [mailto:[Email Address Removed] 30 December 2003 02:23
To: LazyDBA.com Discussion
Subject: Query Analyzer


Hi all,
Can anyone suggest a way to retrieve more than two digits to the right of
the decimal point in QA?
Query is fine in OSQL, 0.00 in QA. Any ideas of why and how to get correct
values from the database?
ie;
select cast(1/50 as numeric(20,20))
Results
-----------------------------------------------------
0.00

(1 row(s) affected)
is not what I want.
_____________________________________________________________________
1> select cast(1/50 as numeric(20,20))
2> go

----------------------
.00000000000000000000
(1 row affected)
is what I want.
How can I do this in QA?

Many TIA's

-- chip

****************************************************************************
This email may contain confidential material.
If you were not an intended recipient,
Please notify the sender and delete all copies.
We may monitor email to and from our network.
****************************************************************************
MS Sql Server LazyDBA home page