Re: Multiplying numeric(19,4) Values

Dear Hugo,

Yes you did: originally I was using float numbers and you suggested
use numeric(19,4) however the reason I mentioned it here was because I
didnt know if perhaps I had continued this advice (i.e. to use numeric
(19,4)) too far and should have chosen another data type. It
certainly was not any indication that I believed the original advice,
in the context of my original query: to be incorrect.

Many thanks,

Alex

On Sep 18, 4:32 pm, Hugo Kornelis
<h...@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
On Fri, 18 Sep 2009 01:41:16 -0700 (PDT), alexcn wrote:
Originally when I sought the help of Hugo Kornelis he suggested I have
my values as numeric(19,4)

I don't think I suggested that in the context of this query. I will
probably have suggested you to use NUMERIC with an adequate precision
and scale instead of the MONEY datatype, which has other (more serious!)
issues with multiplication and division.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog:http://sqlblog.com/blogs/hugo_kornelis

.

Relevant Pages

  • Re: SQL Humor
    ... Hugo Kornelis wrote: ... SQL Server will often produce the same execution for both versions. ... the big questions for the RM, *for me* seem to include view updatability which has to do with the operators of the algebra as well as whether a relational engine can implement customary features such as concurrency control and presentation coherence without being written in a language that eschews the relational operators. ...
    (comp.databases.theory)
  • Re: us date format
    ... I don't know the context where Steve recommended using CLng, ... However, even if your front-end is linked to SQL Server, there's no reason why you can't use this "trick" to set the default value for a field. ... clng method when concatenating a dynamic SQL string. ... it to string when concatenating whith the dynamic SQL string? ...
    (microsoft.public.access.formscoding)
  • Re: Package Sercurity Context
    ... Where does it get the context, ... DTS is client-side, so when using Enterprise ... If you schedule a package then you basically get the SQL Server Agent ...
    (microsoft.public.sqlserver.dts)
  • Re: us date format
    ... I don't know the context where Steve recommended using CLng, ... However, even if your front-end is linked to SQL Server, there's no reason why you can't use this "trick" to set the default value for a field. ... ' connection string from here ... it to string when concatenating whith the dynamic SQL string? ...
    (microsoft.public.access.formscoding)
  • Re: Need help with hint syntax in SQL Server 2000
    ... unable to recognize that it shoul push the where clause condition down ... Hugo Kornelis, SQL Server MVP ... My SQL Server blog:http://sqlblog.com/blogs/hugo_kornelis ... Thank you both for the replies. ...
    (comp.databases.ms-sqlserver)
Quantcast