Welcome to Sign in | Help

cum fac CAST/CONVERT-ul ?

  •  02-16-2007, 3:04 PM

    cum fac CAST/CONVERT-ul ?

    salut....am intr-o tabela campurile

    QASStation as nvarchar,

    TimeStation as int

    si vreau sa realizez

    cast(convert(decimal,count(QASStation) * TimeStation/3600) as decimal(5,2)) as OREOptim

    deci ...................count(QASStation)*TimeStation/3600

    asfel incat rezultatul sa aiba 2 zecimale...sa nu rotunjeasca

    P.S. va rog nu stergeti Post-ul chiar daca este unul asemnator pe English Section pt ca sunt diferite.

View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems