Float type

I inhereted a database that has a lot of Float type columns. Typically
these columns hold decimal-type data rounded to four decimal points
such as:
987.1234
Is Float the appropriate data type for use with these types of columns?Float is generally referred to as an approximate datatype (approximate for the 10.base system, which
us humans tend to use). This mean that a value you input might not be the one which is stored, just
try below:
SELECT CAST(3.1 AS float)
If above is not acceptable, then use NUMERIC with a scale of 4 instead, like:
SELECT CAST(3.1 AS numeric(9,4))
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"laurenq uantrell" <laurenquantrell@.hotmail.com> wrote in message
news:1135913496.671119.91530@.g49g2000cwa.googlegroups.com...
>I inhereted a database that has a lot of Float type columns. Typically
> these columns hold decimal-type data rounded to four decimal points
> such as:
> 987.1234
> Is Float the appropriate data type for use with these types of columns?
>

Fixed Height - Invoices

Hi,
I am trying to create invoices, quotes, order documents using RS.
Typically for these documents, the totals go at the footer of the report.
We also have lines indicating columns so it's easy to look down the totals
column. How might you do this in RS?
many thanks
MattTo elaborate further, this would be partially resolved if we could put a
total in the page footer. Is there a way we can sum a field and use the
result of this in our page footer?
Finally, how would we make our column lines go from the page header to the
page footer?
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:uHm0yg8kEHA.324@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I am trying to create invoices, quotes, order documents using RS.
> Typically for these documents, the totals go at the footer of the report.
> We also have lines indicating columns so it's easy to look down the totals
> column. How might you do this in RS?
> many thanks
> Matt
>
>