jeffrey yao (9/24/2015)
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.
In case, you want to take another approach to this "HTML formatted table report", here it is 😛
https://www.mssqltips.com/sqlservertip/4032/generate-html-formatted-emails-from-sql-server/
Cheers !
I guess my question would be, since it's just as complicated as doing it in T-SQL, why would you want to use the extra complication and addition to the proverbial "Tower of Babel" by using PowerShell?
--Jeff Moden
Change is inevitable... Change for the better is not.