Data:

PROJ PLAN TOTTIME UNIT
A P1 10 DAY
A P2 10 HOUR
A P3 1 MONTH


WHEN I'M DOING GROUP BY ON PROJ

AND CALCULATING TOTTIME IT CONSIDER ONE OF THE UNIT I.E. DAY, HOUR, MONTH

I WANT TO SUMUP ALL WITH HAVING UNIT CALCULATION ALSO.


10 DAY=10 DAYS
10 HOUR=1.25 DAYS
1 MONTH=20 DAYS

THE RESULT SHOULD BE LIKE THIS:

PROJ PLAN TOTTIME (IN DAYS)
-------------------------------
A ALL 31.25
-------------------------------





THANKS IN ADV.

T.S.NEGI
tilak.negi@mind-infotech.com

tilak.negi@mind-infotech.com (T.S.Negi) wrote in message news:<a1930058.0401052155.53e0e35a@posting.google. com>...
> Data:
>
> PROJ PLAN TOTTIME UNIT
> A P1 10 DAY
> A P2 10 HOUR
> A P3 1 MONTH
>
>
> WHEN I'M DOING GROUP BY ON PROJ
>
> AND CALCULATING TOTTIME IT CONSIDER ONE OF THE UNIT I.E. DAY, HOUR, MONTH
>
> I WANT TO SUMUP ALL WITH HAVING UNIT CALCULATION ALSO.
>
>
> 10 DAY=10 DAYS
> 10 HOUR=1.25 DAYS
> 1 MONTH=20 DAYS
>
> THE RESULT SHOULD BE LIKE THIS:
>
> PROJ PLAN TOTTIME (IN DAYS)
> -------------------------------
> A ALL 31.25
> -------------------------------
>
>
>
>
>
> THANKS IN ADV.
>
> T.S.NEGI
> tilak.negi@mind-infotech.com

Here is one way to do the summing using a CASE statement


SELECT
SUM(CASE UNIT
WHEN 'DAY' THEN TOTTIME
WHEN 'HOUR' THEN TOTTIME * 0.125
WHEN 'MONTH' THEN TOTTIME * 20
END)
FROM
PLANSAMPLE
WHERE
<CONDITION>
GROUP BY
<Grouping>