Interesting, how SQL works unlike traditional languages. Thanks Guys. Thanks for your help.

I can do that. Except that the tablename also comes from another variable. So, I have to use a dynamic sql.

Declare @tablename sysname

set @tablename = 'authors'

set @strsql = 'select...

SOMEONE REPLY PLEASE. I AM SURE MANY OF YOU HAVE DONE THIS.

Sorry, lot of the stuff you talked about are way over my head.

When you talk about Pivot table, which software are you talking about? Are you talking about the...

I have not seen anything like that. But one would think there got to be a product available in the market to do that. Just a thought - it is...