Hi,

Above mentioned query is given expected output in sql 2000 too.

I modified few settings in query analyzer in order to increase the maximum characters per column for result set and...

I am facing few problems as all the columns except one are dynamic. But I am working on that.

Thanks a lot.

Thanks J-F.

I think this approach can solve my problem listed earlier.

But I have come across another problem. When I try excuting following query on PUB database its showing me...

Thanks a lot. That helped. 🙂