Hi Aditya,

I think you should be able to do it using PIVOT. Have a look on

http://www.mssqltips.com/sqlservertip/1019/crosstab-queries-using-pivot-in-sql-server/

Thanks Sean.

The problem was something different but fortunately I nailed it. The extended stored procedure actually tries to communicate with Message Queue Server which has been upgraded to Message queuing...

Yes, I did. I tried with run as Administrator as well. Thanks any-ways, for your comment.

Thanks Paul,

I will check it today.

Thank you all for your great comments.

Yes the CUSSOR was deallocated and closed. As I mentioned in my original post it is working fine with 2000. I had read...

Thank you for your reply. I agree on what you said, but I have no idea how to check the dependencies of those dlls.