Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Steve Moore Email Formatted HTML Table with T-SQL RE: Email Formatted HTML Table with T-SQL

  • October 7, 2015 at 8:47 pm

    #1832200

    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

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)