• 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 !