"David Clifford" <sarpg939tNoSpam@ntlworld.com> wrote in message
news:uCb6xnS2EHA.1396@tk2msftngp13.phx.gbl...
> Hello .
>
> I have just migrated a rather large QA database to SQL server 7..the one
> that came free with VB6 pro. I am really quite new to SQL Server.
> My question is:
> Many fields contain laboratory results for analytes that were stored as
> single data types in Jet 4.0 Typically the results would be 1.23, 1.45,
> 3.66, 2.66, 1.55, 1.52 etc etc. Mostly 2 decimal places. My conversion to
> SQL server 7 has assigned these single data types as Real. Looking at my
> reference book, it says not to use this data type as it can be inaccurate.
> The book recommends Decimal, Money or Small Money data types. However, at
2
> decimal places, how inaccurate would it have to be? So, my question is,
as
> it is not recommended to use the Real data type, what data type should I
use
> to store these values?
>
> Thank you for your time.
>
>

"Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
news:OSzKSKV2EHA.3392@TK2MSFTNGP10.phx.gbl...
> If you need exact, use decimal.
>
> With real, you could have a scenario where 1.2999999999999999999 is used
> instead of 1.30
>
> Regards
> --------------------------------
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
>
> IM: mike@epprecht.net
>
> MVP Program: http://www.microsoft.com/mvp
>
> Blog: http://www.msmvps.com/epprecht/
>
> "David Clifford" <sarpg939tNoSpam@ntlworld.com> wrote in message
> news:uCb6xnS2EHA.1396@tk2msftngp13.phx.gbl...
> > Hello .
> >
> > I have just migrated a rather large QA database to SQL server 7..the one
> > that came free with VB6 pro. I am really quite new to SQL Server.
> > My question is:
> > Many fields contain laboratory results for analytes that were stored as
> > single data types in Jet 4.0 Typically the results would be 1.23, 1.45,
> > 3.66, 2.66, 1.55, 1.52 etc etc. Mostly 2 decimal places. My conversion
to
> > SQL server 7 has assigned these single data types as Real. Looking at my
> > reference book, it says not to use this data type as it can be
inaccurate.
> > The book recommends Decimal, Money or Small Money data types. However,
at
> 2
> > decimal places, how inaccurate would it have to be? So, my question is,
> as
> > it is not recommended to use the Real data type, what data type should I
> use
> > to store these values?
> >
> > Thank you for your time.
> >
> >
>
>