Issues in creating Stored Procedure

See more:

SQL-server-2000

SQL-Server

Hi all,

I am having some issues in SQL SP.
I am having a table like this with the name Master.

EmpID Name Mode Normal_ot Dayoff_ot
1 aaa absent 0 0
2 bbb Present 0 1
3 ccc Present 1 0
2 bbb Present 2 0

from this i need to generate a report with these fileds

EmpID Name ttl_Absent tt_Present Normal_ot Dayoff_ot
1 aaa 1 0 2 1
2 bbb 0 2 2 1
3 ccc 0 1 1 0

for this how can i write the SP or is there any other ways to generate report other than creating an Stored Procedure. I'm using crystal report to generate the report, so am i can generate this report with crystal report formulas.

Also using the c# windows form in the front end.

Please any one can help me in this case

Thanks in Advance...