Re: SQL Question.

["Carel Teijgeler" <coteijgeler@xxxxxxxxx>]

Alan,

If you want percentages, multiply the second Sum(ONTSHP) with 100, now your
result is more than two decimals.

Regards,
Carel Teijgeler

*********** REPLY SEPARATOR  ***********

On 8-11-2006 at 10:24 Alan Campin wrote:

> Anybody got any idea why this does not work? Why does calculation always
produce zero? Am I losing it here?
> Problem has nothing to do with Cast as I can try it with and without and
same result. 
> Anyway, thanks. 
>
> Select SMONTH,
>       Cast(Sum(ONTSHP) AS Dec(7,0)) As TONT,           
>       Cast(Sum(TOTSHP) As Dec(7,0)) As TSHP,
>       Cast(Sum(ONTSHP) / Sum(TOTSHP) As Dec(7,2)) As ON_TIME_P 
>  From LEADCSHP
>  Where SCUST Not In(70500,89900,70600)
>  Group By SMONTH
>  Order by SMONTH  
>
> Month        TONT        TSHP   ON_TIME_P      
>     1       1,408       1,782         .00      
>     2       1,660       1,686         .00      
>     3       1,336       1,376         .00      
>     4       2,242       2,266         .00      
>     5       2,020       2,052         .00      
>     6       2,188       2,226         .00      
>     7       1,878       1,908         .00      
>     8       1,960       1,972         .00      
>     9       2,018       2,022         .00      
>    10       2,060       2,074         .00      
>    11       2,052       2,072         .00      
>    12         931         942         .00      
>    13       1,039       1,056         .00