Query rounds off percentages, would like actual numbers 1

[beetlebailey]

The following query rounds off the percentage to the closest whole number like: 96.00% I would like to see the actual value like: 95.59% Any ideas please ?

cast(sum(Hour1)/(cast(Tact1 as decimal(6,2))) as decimal(6,2))*100 as Percent1

SQL 2000, Windows 2000 Pro SP4

Thank you....

 

[amrita418]

Try this:

select cast(sum(22)/cast(19 as decimal(6,2)) * 100 as decimal(6,2)) as Percent1

Regards,
AA

 

[Pattycake245]

Why not just:

(sum(Hour1)/(Tact1*1.0))*100 as Percent1

Tim

 

[zhavic]

Also do the multiplication first before dividing to get rid of loosing precision

SELECT 100.0 * sum(Hour1) / Tact1 AS Percent1

Zhavic


---------------------------------------------------------------
In the 1960s you needed the power of two Comodore64s to get a rocket to the moon. Now you need a machine which is a vast number of times more powerful just to run the most popular GUI.

 

[amrita418]

The original poster wants the output only until 2 decimal places.

Regards,
AA

 

[Pattycake245]

OK then

cast(sum(Hour1)/(Tact1*1.0)*100 as decimal(9,2)) Percent1