hi, If you had a separate table for the designations for that employees then u can join both the tables and get what ever fields u have and make aliasing names for that columns... Otherwise it is not possible to get because u are not having the designation column in the Your table

hi, select COUNT(Category_name) from TableName where Category_name like '%food%' group by Category

S Azarudhin

hi, you are telling that your sp is big instead of at one time u debugging can u cut that sp and check which part is throwing error in your Sp because i had also tried like that only when i faced this situation. I think it will help you. Regards, S Azarudhin