I was just going through pivot example.As you said in pivot you need to hard wire columns. Can we not built a string of column values dynamically for dynamic pivot...

I posted similar question. And I got answer from these guys.

Check this out

http://www.sqlteam.com/item.asp?ItemID=2368

Thanks for the post.

Very simple,perfect.Would like to see similar post from you

Hi,

You can try following

select

ArticleID from tblAuthorArticle group by ArticleID having count