Posted by tatata9999 on 10/07/07 01:43

On Oct 5, 2:16 am, Erland Sommarskog <esq...@sommarskog.se> wrote:
> (tatata9...@gmail.com) writes:
> > I've tried DECIMAL(1) and (2) respectively to no avail. Do you have a
> > sample one? Thanks.
>
> Decimal(1) means a number in the range 0-9 with no decimals.
>
> I usually sort this out by simply multiplying with 1.0. Like in many other
> languages, / in T-SQL is integer division when two integers meet.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Interesting idea, Erland, but it did not seem to work for me, maybe I
didn't do it right? Only two variations.

[Back to original message]