Thanks , i will have a look and get back

SQL Server 2005

Thanks for yor comments .... I fully agree with what you are suggesting ... I know that i might not the right person to implement this , but...

My experience is mainly on the C++ , C# ... Have not used much of databases , just a few queries here and there , so i am not aware...

Thanks for the confirmation... i also did that and got the same rsult

Thanks , both the cross tab and pivot worked

Thanks for the reply... will try this and get back