Yak Posting Veteran
Posted - 11/28/2008 : 02:00:36
| my problem is as follows....
i am having a result set containing columns
where leave type can be of three categories
normal,on duty and on tour
now i want to display userid,deptname and in seperate columns how many times user went on -on duty,normal or was on tour
basically problem is how to compare column value in a table with a given criteria and display it in a seperate column