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

  • March 15, 2016 at 9:30 am

    #1865292

    tauseef.jan (3/15/2016)

    Thankyou so much for the code snippet.

    But I have a problem, that I have EMPTY(NULL) columns.

    because of this the columns in the email get shifted to the left.

    Please help to resolve this

    Most likely, you'll need to replace the "empty" cells with non-breaking spaces (I forget the HTML entitization code for that but should be easy for you to find).

    --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)