Sorry mate i was looking for SSRS matrix solution...the data i had given is a test data, als the columns are dynamic..

Thanks for the effort....:-)

Take the output from open query in a temp table..and join this to another ...

Thanks mate, it really helped........

Thanks a lot Niraj, I got to know more about matrix, also I got to do it with pivot operator in SQL 2005...