http://sqlserver.ro/forums/15/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/1847.aspxFri, 16 Feb 2007 13:23:13 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:1847Alex0http://sqlserver.ro/forums/thread/1847.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=1847<P>am rezolvat.....multumesc</P> <P>&nbsp;</P>http://sqlserver.ro/forums/thread/1846.aspxFri, 16 Feb 2007 13:04:57 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:1846Alex0http://sqlserver.ro/forums/thread/1846.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=1846<P>salut....am intr-o tabela campurile</P> <P>QASStation as nvarchar,</P> <P>TimeStation as int</P> <P>si vreau sa realizez </P> <P>cast(convert(decimal,count(QASStation) * TimeStation/3600) as decimal(5,2)) as OREOptim</P> <P>deci ...................count(QASStation)*TimeStation/3600</P> <P>asfel incat rezultatul sa aiba 2 zecimale...sa nu rotunjeasca</P> <P>P.S. va rog nu stergeti Post-ul chiar daca este unul asemnator pe English Section pt ca sunt diferite.</P>