jeffrey yao (8/28/2015)
This is a nice article that generates lots of interesting discussions and topics.But from pure technical perspective, I feel there is one special deficiency I do not like, that is: hard-coding of column names and lack of flexibility to handle multiple queries.
I recently submitted an article to mssqltips.com, and in that article, I addressed this deficiency with the help of PowerShell and .Net. The article is accepted and should appear soon.
Heh... I think it's a deficiency to have to use PowerShell and .Net to do such a simple thing. 😉 I also agree that it would be nice to have something generic that has dynamic column names and table sources but the purpose of this article wasn't to provide a total solution. It was meant to demonstrate how to easily generate HTML for a given table output. From there, you can certainly let your imagination lose.
Looking forward to your good article, Jeffrey. Thanks for the heads up.
--Jeff Moden
Change is inevitable... Change for the better is not.