HTML Table Results For Email

  • Comments posted to this topic are about the item HTML Table Results For Email

  • This was interesting and it generated an interesting result in my case.
    data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAABC8AAAHpCAYAAACiOBYzAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAB27SURBVHhe7d09dtvG1wdg+N2AN2GnyMkK5BXY/yZVWnVyGTfpUqZLY5dRFbWp3MRegb0CnxSxFxGvQC8GBCSQJmcoiRKurp7nHNnQBwlg8EHgR96ZR+e9DgAAACCo/xv/BwAAAAhJeAEAAACEJrwAAAAAQhNeAAAAAKEJLwAAAIDQhBcAAABAaMILAAAAIDThBQAAABCa8AIAAAAITXgBAAAAhCa8AAAAAEJ7dN4bpwdfv34dpwAAAACWtzW8ePz48fgdAAAAwLKUjQAAAAChVT95cXZ2Nvyf2fHx8fD/Q1jXpTzENrZfaYOb0Hb3k+12v9l+Mdkusd3H7ZN1n7rP62XZl3Evl72EF3P//fffOHV+/ueff45TOT2kdV3KQ2xj+5U2uAltdz/Zbveb7ReT7RLbfdw+Wfep+7xeln0Z93XZlY0AAAAAoQkvAAAAgNCEFwAAAEBowgsAAAAgtCuEF++7l48edc/efBm/P6wvb551jx697OdSrOb1aO1r+l3D+5cHWMZ7sq4HtL5Md+Gu2vhL9+bZZvuuvl7edSNv3dbPuqEJvrzpnu2zTPv8XfVvlj62Vt6/nM3/2Zt+K41uOo9927FqWxstsb/sMK7jWrtd0drxvtlma9tgobbol+HO2vwa+9y1zpcPYbuN85235+pYv2Jb9fZu41vfftc9Z2573Hi+3/o7x9WD3S7jfPMfN/3XoRtzbZ++7j4xuenj9zRv+4Ncs+xj81p42udv0bZ97Frru/yyr12zXmnhYy371Y75IPvMtByza6fQn7w4ev25jIYyfL07Oe1eNC/6+hPPi9Nx+n65XNd33UnXr+vtn8keiCfdzx9W+9Dn10f99yfdu3Gf+uP56i/u2ny/Pj//0P38pP/hk5+7D/ss075/17DosdW/eP3WP9XJu37+n193Rx9fdcfDyeoA8zhQ+xTzNir7zumLW7iIuYYvf//VfSwTH//q/q5vtP2stdn2bRC1LW7u7l4zbLfbcHfb7+rnzJX54y7O9yPH1c3ZLtexzPYZvg7x4txw3X1ictPH1220/QGvWXYrN39Pu1fd6+7zuF79pVf36ult3oxu2cdKcPH01ep1cG8Blr2/oS7fXlyznr7YMwQItuzvTrqPr473nHeQfab35c1x92pjpzlceNE30K50Zte7rJc/f9b9/s/4wx2e/3jSX/S96n4fX0G+fc7S0C/62/7yZ08vkrFVUjz+3aECgVtd1+ddWdXu07/dl3E+z56t1mFY/Mq819Z1Nu9dbbBzmcZ5rP60tOvs+bYs0/1r48nGuk3fl3WY2uDl5XLMV+3g6zxPo6fp2bwvTpRrqfW4vOPfbC7Hp98ul7F2or3zY+vzP5cvXuML94efu63z2Gdbv3xZlmO8uNy3HXs7n2OLJ9/90P/7qfv3cgEunvNy/5ztP+W7sX1W385/V99ude+738tZ/OSk61+Gur/md8G147a38/i4aLPt23nTnbdFdTvufvzW/XNc1un89ejR/vv1zvbbywPcbttM67rjvFpr48vf9V/XOC/dbPut2zxnHoLjynbZKclxc2Fjf5nWa69r3c3Hvh1/vsNN94m1x0/bYXiucVtO5+rN5er/Zq+2vziPlyfp7Vrv6vHa8P73/ubvqHt99nM3ZXRPfv7Q35DOQrtGe29d553LtGM9S3BxdNSVtxH3FmHZn/8x3LwPAdOT77pyRthLsGX/8u+n8uj9RFj2ov/741dd1+82aw4TXpSFeXF6kVa+O/nYvXo63gj0K/HidHy3uyRWs5PARRp0ftZ9/6mRxT39ftjhP5VXkK3PWd5hL59aGFPTsqX6v3v66ofxnfb+d3unZRW3vq7vu7dl6/3w3cUO0/10Nszrj6f1eT/tL45X8+jXtZ/38G72rja40jJtMS1Tdx/beNLvM7+WF6bxndAvf3d/lfuLHy8j8NPux2EZ1t592dWmexoOzPGgvThAt5jm/W547fx9Ne+54eQyrnP5o9PfLk8evY8//Fp//OSuj63nv3R9c/btOTuhlW2xZR6H2NZb2/GKz/F+dVB235WDcuf++aT7309lxd4O8/j8z+o5h3ad71uN7Vb1/u1wcj/58Y8h5Pz4199j+zXstb5btsEWS7XF9u244/Gt/XM8fw2/679t7tdX3F++8YC32za7zqs713X43Q3OSzfdfpvm58yGfc/3jivbpeU+Hjdr7dx/rTX1dB3548b3tWvdyeZjd7nCPrHVVR8/LVd/bbxX28/t3L8ubT1eG1Y3reM+vM0e8635dpl2rOfJu+787KfV9J7CLPvo/cvVDfYPOxfoUqhlH47xrnv9ef1TZrvEWPYv3ZvjstBn3a8bidFBwovVx2FPul/HFnn+S3+g9ov2tqzFkPr82L0tJ67Zx4VWDXPSlfN5ufgaTvz72vGcm1YvOqfdi+GkOSY6/3wefnddt7Wulyf4spz9CW+2000HSW3e6/N43v3R7xQf+r/b1QY3av/etEz3qY23ev5j/6iPXVnkab6r51gZLjh6q3dfVstw03WeDvbha+PEODfN++n3O9ZlfFEdQoDhJHK2dlJqPn6bOzm2ykmqX/fVWat72j/H2gXw5EDbels7XO2YfNRfhBz1J/0/+iOrvn8++d9P4/QqhDw6OhpuVN/P963GdqsZ2v3odfdL/zxXeUfppsd7hLbYuj/veHxr/9x14bHrcTdtv4e83bbZdl6trusNz0s3bcebqJ3vHVe2S/bjZq2d+695U2/uL/tc60527WtLu1iuPdt+bp/13nq83tA+863Za5nKp2wr17vXdSfLPiqfTuoP27JTD6/lN3WXyz7sj59/6v56uuN6+4ruYtmHcpHudXc2zmPu1vu8WH0U7UXXleS2pI/jz6+rnBiu9pxj8jl93cLBM7nJuq6f4FcvlIdz221wP9p4u1WZzunbN93fq7dH9mz7u1vnncaSi5IBFOWC6yYnpTs/toYX98/DpzDKRd7mkh9+W1/NdEyu2reSQM89+V9Xru8+vX3bferb59ez/oL24z/d2/JO3LRvXXu7rS6K+wcMgU+5+C1O9321uIF4bTGqPv66++ehj23brTv6vns6Tl5H1Nf8m95AOa5uR5rtkvS4WcJN94mrPn7p65e5b0qf7pEoy162Z/l0+3CcfLgspagJ1+5jycs8cN5l+WX/sronG6+bhsumMj1+Wvsg4cWUOP82noTf/15SxlVau/r43Jjczmrd58nxxUJWDM85pl27nnPT8A7XNI/yEZe+ASqfDtzLXazrLrV5b85jqDHqV3ZXG1SXaXx3YPUxuc/dsFo7ZGjjYR1OX60+zjk88aXpBmP+DsRtrPO1vC81Y8+6f38pFxurj1tdx10fW6sX9ak+bty/5mVSo9s8nq7yHM//KG17etFpV23/7H87vDv18fS0b9P+wnN4sTjt+m8v961rbrcvb37rn6m8CzheXE4XweNHlWvH7SHarIjSFhd2PP66++eux92k/R7WdnvalTdSLsPIL91w6tw4vredV2vretPz0qHacTI/Zx6C46r81UPeLg/juNlXvZ2v5qb7xNrjr3BtvG/bzx1yvdcMpbofu1fHq/24mF+HVed7hXW+FRGWvT8mjqfg4ipvLgdY9rXr7S//dsOZY58davFlHz+hPb9m6o/Dz1Nw1P9wzX///TdOnZ//+eef41Tx7rx/7Hl5yPzr5N3065PZz4/O+wu1lc+vz/uVWP386GiYPhp/2S/Mxd+fnBz1/5/0cxl+s2Ve0+96O5/z8/nro/Hn44JdzuPyZ5NI6zr93ZpxPmuLvWvevc+vy/OOvzt63bfGyq422L1Ms3Y8Ojk/KdPT821ZpvhtvLJqn/WfrUzLMvvdtJ4nl8txqHXeuq3H9Rqeaj49fDtb7o3frS3HtI1qj79Y1/nXbL13tu+hjq1i9lzD1zT/jXnsXJb5vDe29Xzdq+1QeY7+32+207g/XPyschxO811f1lkb97Zut9H2thvbZuNvp+VYrWPluO3t1Wbz5xh+sFBbzNdr7+04e/zmz6cHr7VXsbm+Ox7Xu/z59vOL7TbZPMfMHjetd/O8un1dh99d87y087lHV3utWn/sdlu2wQXH1eTy5w94uww212f2uKl97/1x03+Vdd7cX77Zf3q72rn62P32ievvU5Vz9eZy7dv2G8fhzvVuHK/F7vUqZvPdfO5i13xr61xdpm/3scHm+o4iL/vqd+P349f8HBG93efH9ny5i3uxz/SGdZieo3eF8CKfh7SuS7kfbbz7gmXj+NmL/eqW22Bj26yf/PZ0iOe4Jfaf+8l228MNzqu3zfaLyXbpOW4OKus+dZ/Xy7Iv474u+633eQGRrT4GVTqoOrnoeIbg5qOVPHo01CGevLtiPzGHeA7gYRs/Yj917jj/2qecgltiuwCkJbzgQVuNW1w+gbRx4zp0JrneMzZRrNfCXW87HeI5gCvJdl4dO2Ccn0emL+eTBWXbLq5HAC4ILwAAAIDQhBcAAABAaI/Oy2fRZr5+/do9fvz4Yjq7h7SuS3mIbWy/0gY3oe3uJ9vtfrP9YrJdYruP2yfrPnWf18uyL+M+Lns1vAAAAABYmrIRAAAAILTqJy/Ozs6G/zM7Pj4epwAAAICImuFF5pt7JTIAAAAQn7IRAAAAIDThBQAAABCa8AIAAAAIrdrnRZnOTp8XAAAAEFs1vAAAAABYmrIRAAAAILTmUKnZZR4KFgAAADJohheZb+6VyAAAAEB8ykYAAACA0IQXAAAAQGjCCwAAACC0ap8XZTo7fV4AAABAbNXwAgAAAGBpykYAAACA0JpDpWaXeShYAAAAyKAZXmS+uVciAwAAAPEpGwEAAABCE14AAAAAoQkvAAAAgNCqfV6U6ez0eQEAAACxVcMLAAAAgKUpGwEAAABCaw6Vml3moWABAAAgg2Z4kfnmXokMAAAAxKdsBAAAAAhNeAEAAACEJrwAAAAAQqv2eVGms9PnBQAAAMRWDS8AAAAAlqZsBAAAAAitOVRqdpmHggUAAIAMmuFF5pt7JTIAAAAQn7IRAAAAIDThBQAAABCa8AIAAAAIrdrnRZnOTp8XAAAAEFs1vAAAAABYmrIRAAAAILTmUKnZZR4KFgAAADJohheZb+6VyAAAAEB8ykYAAACA0IQXAAAAQGjCCwAAACC0ap8XZTo7fV4AAABAbNXwAgAAAGBpykYAAACA0JpDpWaXeShYAAAAyKAZXmS+uVciAwAAAPEpGwEAAABCE14AAAAAoQkvAAAAgNCqfV6U6ez0eQEAAACxVcMLAAAAgKUpGwEAAABCaw6Vml3moWABAAAgg2Z4kfnmXokMAAAAxKdsBAAAAAhNeAEAAACEJrwAAAAAQqv2eVGms9PnBQAAAMRWDS8AAAAAlqZsBAAAAAitOVRqdpmHggUAAIAMmuFF5pt7JTIAAAAQn7IRAAAAIDThBQAAABCa8AIAAAAIrdrnRZnOTp8XAAAAEFs1vAAAAABYmrIRAAAAILTmUKnZZR4KFgAAADJohheZb+6VyAAAAEB8ykYAAACA0IQXAAAAQGjCCwAAACC0ap8XZTo7fV4AAABAbNXwAgAAAGBpykYAAACA0JpDpWaXeShYAAAAyKAZXmS+uVciAwAAAPEpGwEAAABCE14AAAAAoQkvAAAAgNCqfV6U6ez0eQEAAACxVcMLAAAAgKUpGwEAAABCaw6Vml3moWABAAAgg2Z4kfnmXokMAAAAxKdsBAAAAAhNeAEAAACEJrwAAAAAQqv2eVGms9PnBQAAAMRWDS8AAAAAlqZsBAAAAAitOVRqdpmHggUAAIAMmuFF5pt7JTIAAAAQn7IRAAAAIDThBQAAABCa8AIAAAAIrdrnRZnOTp8XAAAAEFs1vAAAAABYmrIRAAAAILTmUKnZZR4KFgAAADJohheZb+6VyAAAAEB8ykYAAACA0IQXAAAAQGjCCwAAACC0ap8XZTo7fV4AAABAbNXwAgAAAGBpykYAAACA0JpDpWaXeShYAAAAyKAZXmS+uVciAwAAAPEpGwEAAABCE14AAAAAoQkvAAAAgNCqfV6U6ez0eQEAAACxVcMLAAAAgKUpGwEAAABCaw6Vml3moWABAAAgg2Z4kfnmXokMAAAAxKdsBAAAAAhNeAEAAACEJrwAAAAAQqv2eVGms9PnBQAAAMRWDS8AAAAAlqZsBAAAAAitOVRqdpmHggUAAIAMmuFF5pt7JTIAAAAQn7IRAAAAIDThBQAAABCa8AIAAAAIrdrnRZnOTp8XAAAAEFs1vAAAAABYmrIRAAAAILTmUKnZZR4KFgAAADJohheZb+6VyAAAAEB8ykYAAACA0IQXAAAAQGjCCwAAACC0ap8XZTo7fV4AAABAbNXwAgAAAGBpykYAAACA0JpDpWaXeShYAAAAyKAZXmS+uVciAwAAAPEpGwEAAABCE14AAAAAoQkvAAAAgNCqfV6U6ez0eQEAAACxVcMLAAAAgKUpGwEAAABCaw6Vml3moWABAAAgg2Z4kfnmXokMAAAAxKdsBAAAAAhNeAEAAACEJrwAAAAAQqv2eVGms9PnBQAAAMRWDS8AAAAAlqZsBAAAAAitOVRqdpmHggUAAIAMmuFF5pt7JTIAAAAQn7IRAAAAIDThBQAAABCa8AIAAAAIrdrnRZnOTp8XAAAAEFs1vAAAAABYmrIRAAAAILTmUKnZZR4KFgAAADJohheZb+6VyAAAAEB8ykYAAACA0IQXAAAAQGjCCwAAACC0ap8XZTo7fV4AAABAbNXwAgAAAGBpykYAAACA0JpDpWaXeShYAAAAyKAZXmS+uVciAwAAAPEpGwEAAABCE14AAAAAoQkvAAAAgNCqfV6U6ez0eQEAAACxVcMLAAAAgKUpGwEAAABCaw6Vml3moWABAAAgg2Z4kfnmXokMAAAAxKdsBAAAAAhNeAEAAACEJrwAAAAAQqv2eVGms9PnBQAAAMRWDS8AAAAAlqZsBAAAAAitOVRqdpmHggUAAIAMmuFF5pt7JTIAAAAQn7IRAAAAIDThBQAAABCa8AIAAAAIrdrnRZnOTp8XAAAAEFs1vAAAAABYmrIRAAAAILTmUKnZZR4KFgAAADJohheZb+6VyAAAAEB8ykYAAACA0IQXAAAAQGjCCwAAACC0ap8XZTo7fV4AAABAbNXwAgAAAGBpykYAAACA0JpDpWaXeShYAAAAyKAZXmS+uVciAwAAAPEpGwEAAABCE14AAAAAoQkvAAAAgNCqfV6U6ez0eQEAAACxVcMLAAAAgKUpGwEAAABCaw6Vml3moWABAAAgg2Z4kfnmXokMAAAAxKdsBAAAAAhNeAEAAACEJrwAAAAAQhNeAAAAAKEJLwAAAIDQhBcAAABAaMILAAAAIDThBQAAABCa8AIAAAAITXgBAAAAhCa8AAAAAEITXgAAAAChCS8AAACA0IQXAAAAQGjCCwAAACA04QUAAAAQmvACAAAACE14AQAAAIT26Lw3Tg++fv3aPX78+GI6u2ldAQAAgJiq4QUAAADA0pSNAAAAAKFVP3lxdnY2/J/Z8fHxOAUAAABE1AwvMt/cK5EBAACA+JSNAAAAAKEJLwAAAIDQhBcAAABAaNU+L8p0dvq8AAAAgNiq4QUAAADA0pSNAAAAAKE1h0rNLvNQsAAAAJBBM7zIfHOvRAYAAADiUzYCAAAAhCa8AAAAAEITXgAAAAChVfu8KNPZ6fMCAAAAYquGFwAAAABLUzYCAAAAhNYcKjW7zEPBAgAAQAbN8CLzzb0SGQAAAIhP2QgAAAAQmvACAAAACE14AQAAAIRW7fOiTGenzwsAAACIrRpeAAAAACxN2QgAAAAQWnOo1OwyDwULAAAAGTTDi8w390pkAAAAID5lIwAAAEBowgsAAAAgNOEFAAAAEFq1z4synZ0+LwAAACC2angBAAAAsDRlIwAAAEBozaFSs8s8FCwAAABk0AwvMt/cK5EBAACA+JSNAAAAAKEJLwAAAIDQhBcAAABAaNU+L8p0dvq8AAAAgNiq4QUAAADA0pSNAAAAAKE1h0rNLvNQsAAAAJBBM7zIfHOvRAYAAADiUzYCAAAAhCa8AAAAAEITXgAAAAChVfu8KNPZ6fMCAAAAYquGFwAAAABLUzYCAAAAhNYcKjW7zEPBAgAAQAbN8CLzzb0SGQAAAIhP2QgAAAAQmvACAAAACE14AQAAAIRW7fOiTGenzwsAAACIrRpeAAAAACxN2QgAAAAQWnOo1OwyDwULAAAAGTTDi8w390pkAAAAID5lIwAAAEBowgsAAAAgNOEFAAAAEFq1z4synZ0+LwAAACC2angBAAAAsDRlIwAAAEBozaFSs8s8FCwAAABk0AwvMt/cK5EBAACA+JSNAAAAAKEJLwAAAIDQhBcAAABAaNU+L8p0dvq8AAAAgNiq4QUAAADA0pSNAAAAAKE1h0rNLvNQsAAAAJBBM7zIfHOvRAYAAADiUzYCAAAAhCa8AAAAAEITXgAAAAChVfu8KNPZ6fMCAAAAYquGFwAAAABLUzYCAAAAhNYcKjW7zEPBAgAAQAbN8CLzzb0SGQAAAIhP2QgAAAAQmvACAAAACE14AQAAAIRW7fOiTGenzwsAAACIrRpeAAAAACxN2QgAAAAQWnOo1OwyDwULAAAAGTTDi8w390pkAAAAID5lIwAAAEBowgsAAAAgNOEFAAAAEFq1z4synZ0+LwAAACC2angBAAAAsDRlIwAAAEBozaFSs8s8FCwAAABk0AwvMt/cK5EBAACA+JSNAAAAAKEJLwAAAIDQhBcAAABAaNU+L8p0dvq8AAAAgNiq4QUAAADA0pSNAAAAAKE1h0rNLvNQsAAAAJBBM7zIfHOvRAYAAADiUzYCAAAAhCa8AAAAAEITXgAAAAChVfu8KNPZ6fMCAAAAYquGFwAAAABLUzYCAAAAhNYcKjW7zEPBAgAAQAbN8CLzzb0SGQAAAIhP2QgAAAAQmvACAAAACE14AQAAAIRW7fOiTGenzwsAAACIrRpeAAAAACxN2QgAAAAQWnOo1OwyDwULAAAAGTTDi8w390pkAAAAID5lIwAAAEBowgsAAAAgNOEFAAAAEFq1z4synZ0+LwAAACC2angBAAAAsDRlIwAAAEBozaFSs8s8FCwAAABk0AwvMt/cK5EBAACA+JSNAAAAAKEJLwAAAIDQhBcAAABAaNU+L8p0dvq8AAAAgNiq4QUAAADA0pSNAAAAAKE1h0rNLvNQsAAAAJBBM7zIfHOvRAYAAADiUzYCAAAAhCa8AAAAAEITXgAAAAChVfu8KNPZ6fMCAAAAYquGFwAAAABLUzYCAAAAhNYcKjW7zEPBAgAAQAbN8CLzzb0SGQAAAIhP2QgAAAAQmvACAAAACE14AQAAAIRW7fOiTGenzwsAAACIrRpeAAAAACxN2QgAAAAQWnOo1OwyDwULAAAAGTTDi8w390pkAAAAID5lIwAAAEBowgsAAAAgNOEFAAAAEFq1z4synZ0+LwAAACC2angBAAAAsDRlIwAAAEBozaFSs8s8FCwAAABk0AwvMt/cK5EBAACA+JSNAAAAAKEJLwAAAIDQhBcAAABAaNU+L8p0dvq8AAAAgNiq4QUAAADA0pSNAAAAAKE1h0rNLvNQsAAAAJBBM7zIfHOvRAYAAADiUzYCAAAAhCa8AAAAAEITXgAAAAChVfu8KNPZ6fMCAAAAYquGFwAAAABLUzYCAAAAhNYcKjW7zEPBAgAAQAbN8CLzzb0SGQAAAIhP2QgAAAAQmvACAAAACE14AQAAAIRW7fOiTGenzwsAAACIrRpeAAAAACxN2QgAAAAQWnOo1OwyDwULAAAAGTTDi8w390pkAAAAID5lIwAAAEBowgsAAAAgNOEFAAAAEFq1z4synZ0+LwAAACC2angBAAAAsDRlIwAAAEBozaFSs8s8FCwAAABk0AwvMt/cK5EBAACA+JSNAAAAAKEJLwAAAIDQhBcAAABAaMILAAAAIDThBQAAABCa8AIAAAAITXgBAAAAhCa8AAAAAEITXgAAAAChPTrvjdODr1+/do8fP76Yzm5aVwAAACCmangBAAAAsDRlIwAAAEBo33zy4uzsbJwCAAAAWN434QUAAABAJMpGAAAAgNCEFwAAAEBowgsAAAAgNOEFAAAAEJrwAgAAAAis6/4fw/EYzdlD7S0AAAAASUVORK5CYII=

    Excellent header, but strange rows.....
    Thanks!
    Ken
    kbaker20@humana.com

  • A great way to do this!  One thing I noticed is that the consecutive REPLACE functions at the end of the SP don't really do anything (i.e. they replace '<' with itself).  I changed the code to this and it seemed to work: 
    ... + REPLACE(
                REPLACE(@BodyHTML, '&lt;', '<') ,
                '&gt;' ,
                '>') ...

    Note: I have not fully tested this so use at your own risk 🙂

    Thanks for the innovative approach 🙂

  • I suspect posting it replaced the &lt; and &gt; with the HTML replacements.  I also added a <TR> tag for the header which I believe is required for proper HTML form. I also noticed it's not fond of timestamp columns, but then again who is 🙂

        set @ColumnHeader
            = '<table cellpadding="2" cellspacing="2" border="1" style="font-family: Arial; font-size: 8pt"><TR>'
              + @ColumnHeader + '</TR>';

  • Thank you for this article. It works but the final HTML output is broken. I guess it has to do with the tags and since I am not well versed with HTML, I am having a hard time fixing this.

    Here is how it looks in my email message:

    Can anyone please help?

  • hoolash - Tuesday, February 20, 2018 1:03 AM

    Thank you for this article. It works but the final HTML output is broken. I guess it has to do with the tags and since I am not well versed with HTML, I am having a hard time fixing this.

    Here is how it looks in my email message:

    Can anyone please help?

    Are you able to supply the table spec and some sample data?

  • kbaker91 - Monday, February 19, 2018 7:55 AM

    This was interesting and it generated an interesting result in my case.
    data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAABC8AAAHpCAYAAACiOBYzAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAB27SURBVHhe7d09dtvG1wdg+N2AN2GnyMkK5BXY/yZVWnVyGTfpUqZLY5dRFbWp3MRegb0CnxSxFxGvQC8GBCSQJmcoiRKurp7nHNnQBwlg8EHgR96ZR+e9DgAAACCo/xv/BwAAAAhJeAEAAACEJrwAAAAAQhNeAAAAAKEJLwAAAIDQhBcAAABAaMILAAAAIDThBQAAABCa8AIAAAAITXgBAAAAhCa8AAAAAEJ7dN4bpwdfv34dpwAAAACWtzW8ePz48fgdAAAAwLKUjQAAAAChVT95cXZ2Nvyf2fHx8fD/Q1jXpTzENrZfaYOb0Hb3k+12v9l+Mdkusd3H7ZN1n7rP62XZl3Evl72EF3P//fffOHV+/ueff45TOT2kdV3KQ2xj+5U2uAltdz/Zbveb7ReT7RLbfdw+Wfep+7xeln0Z93XZlY0AAAAAoQkvAAAAgNCEFwAAAEBowgsAAAAgtCuEF++7l48edc/efBm/P6wvb551jx697OdSrOb1aO1r+l3D+5cHWMZ7sq4HtL5Md+Gu2vhL9+bZZvuuvl7edSNv3dbPuqEJvrzpnu2zTPv8XfVvlj62Vt6/nM3/2Zt+K41uOo9927FqWxstsb/sMK7jWrtd0drxvtlma9tgobbol+HO2vwa+9y1zpcPYbuN85235+pYv2Jb9fZu41vfftc9Z2573Hi+3/o7x9WD3S7jfPMfN/3XoRtzbZ++7j4xuenj9zRv+4Ncs+xj81p42udv0bZ97Frru/yyr12zXmnhYy371Y75IPvMtByza6fQn7w4ev25jIYyfL07Oe1eNC/6+hPPi9Nx+n65XNd33UnXr+vtn8keiCfdzx9W+9Dn10f99yfdu3Gf+uP56i/u2ny/Pj//0P38pP/hk5+7D/ss075/17DosdW/eP3WP9XJu37+n193Rx9fdcfDyeoA8zhQ+xTzNir7zumLW7iIuYYvf//VfSwTH//q/q5vtP2stdn2bRC1LW7u7l4zbLfbcHfb7+rnzJX54y7O9yPH1c3ZLtexzPYZvg7x4txw3X1ictPH1220/QGvWXYrN39Pu1fd6+7zuF79pVf36ult3oxu2cdKcPH01ep1cG8Blr2/oS7fXlyznr7YMwQItuzvTrqPr473nHeQfab35c1x92pjpzlceNE30K50Zte7rJc/f9b9/s/4wx2e/3jSX/S96n4fX0G+fc7S0C/62/7yZ08vkrFVUjz+3aECgVtd1+ddWdXu07/dl3E+z56t1mFY/Mq819Z1Nu9dbbBzmcZ5rP60tOvs+bYs0/1r48nGuk3fl3WY2uDl5XLMV+3g6zxPo6fp2bwvTpRrqfW4vOPfbC7Hp98ul7F2or3zY+vzP5cvXuML94efu63z2Gdbv3xZlmO8uNy3HXs7n2OLJ9/90P/7qfv3cgEunvNy/5ztP+W7sX1W385/V99ude+738tZ/OSk61+Gur/md8G147a38/i4aLPt23nTnbdFdTvufvzW/XNc1un89ejR/vv1zvbbywPcbttM67rjvFpr48vf9V/XOC/dbPut2zxnHoLjynbZKclxc2Fjf5nWa69r3c3Hvh1/vsNN94m1x0/bYXiucVtO5+rN5er/Zq+2vziPlyfp7Vrv6vHa8P73/ubvqHt99nM3ZXRPfv7Q35DOQrtGe29d553LtGM9S3BxdNSVtxH3FmHZn/8x3LwPAdOT77pyRthLsGX/8u+n8uj9RFj2ov/741dd1+82aw4TXpSFeXF6kVa+O/nYvXo63gj0K/HidHy3uyRWs5PARRp0ftZ9/6mRxT39ftjhP5VXkK3PWd5hL59aGFPTsqX6v3v66ofxnfb+d3unZRW3vq7vu7dl6/3w3cUO0/10Nszrj6f1eT/tL45X8+jXtZ/38G72rja40jJtMS1Tdx/beNLvM7+WF6bxndAvf3d/lfuLHy8j8NPux2EZ1t592dWmexoOzPGgvThAt5jm/W547fx9Ne+54eQyrnP5o9PfLk8evY8//Fp//OSuj63nv3R9c/btOTuhlW2xZR6H2NZb2/GKz/F+dVB235WDcuf++aT7309lxd4O8/j8z+o5h3ad71uN7Vb1/u1wcj/58Y8h5Pz4199j+zXstb5btsEWS7XF9u244/Gt/XM8fw2/679t7tdX3F++8YC32za7zqs713X43Q3OSzfdfpvm58yGfc/3jivbpeU+Hjdr7dx/rTX1dB3548b3tWvdyeZjd7nCPrHVVR8/LVd/bbxX28/t3L8ubT1eG1Y3reM+vM0e8635dpl2rOfJu+787KfV9J7CLPvo/cvVDfYPOxfoUqhlH47xrnv9ef1TZrvEWPYv3ZvjstBn3a8bidFBwovVx2FPul/HFnn+S3+g9ov2tqzFkPr82L0tJ67Zx4VWDXPSlfN5ufgaTvz72vGcm1YvOqfdi+GkOSY6/3wefnddt7Wulyf4spz9CW+2000HSW3e6/N43v3R7xQf+r/b1QY3av/etEz3qY23ev5j/6iPXVnkab6r51gZLjh6q3dfVstw03WeDvbha+PEODfN++n3O9ZlfFEdQoDhJHK2dlJqPn6bOzm2ykmqX/fVWat72j/H2gXw5EDbels7XO2YfNRfhBz1J/0/+iOrvn8++d9P4/QqhDw6OhpuVN/P963GdqsZ2v3odfdL/zxXeUfppsd7hLbYuj/veHxr/9x14bHrcTdtv4e83bbZdl6trusNz0s3bcebqJ3vHVe2S/bjZq2d+695U2/uL/tc60527WtLu1iuPdt+bp/13nq83tA+863Za5nKp2wr17vXdSfLPiqfTuoP27JTD6/lN3WXyz7sj59/6v56uuN6+4ruYtmHcpHudXc2zmPu1vu8WH0U7UXXleS2pI/jz6+rnBiu9pxj8jl93cLBM7nJuq6f4FcvlIdz221wP9p4u1WZzunbN93fq7dH9mz7u1vnncaSi5IBFOWC6yYnpTs/toYX98/DpzDKRd7mkh9+W1/NdEyu2reSQM89+V9Xru8+vX3bferb59ez/oL24z/d2/JO3LRvXXu7rS6K+wcMgU+5+C1O9321uIF4bTGqPv66++ehj23brTv6vns6Tl5H1Nf8m95AOa5uR5rtkvS4WcJN94mrPn7p65e5b0qf7pEoy162Z/l0+3CcfLgspagJ1+5jycs8cN5l+WX/sronG6+bhsumMj1+Wvsg4cWUOP82noTf/15SxlVau/r43Jjczmrd58nxxUJWDM85pl27nnPT8A7XNI/yEZe+ASqfDtzLXazrLrV5b85jqDHqV3ZXG1SXaXx3YPUxuc/dsFo7ZGjjYR1OX60+zjk88aXpBmP+DsRtrPO1vC81Y8+6f38pFxurj1tdx10fW6sX9ak+bty/5mVSo9s8nq7yHM//KG17etFpV23/7H87vDv18fS0b9P+wnN4sTjt+m8v961rbrcvb37rn6m8CzheXE4XweNHlWvH7SHarIjSFhd2PP66++eux92k/R7WdnvalTdSLsPIL91w6tw4vredV2vretPz0qHacTI/Zx6C46r81UPeLg/juNlXvZ2v5qb7xNrjr3BtvG/bzx1yvdcMpbofu1fHq/24mF+HVed7hXW+FRGWvT8mjqfg4ipvLgdY9rXr7S//dsOZY58davFlHz+hPb9m6o/Dz1Nw1P9wzX///TdOnZ//+eef41Tx7rx/7Hl5yPzr5N3065PZz4/O+wu1lc+vz/uVWP386GiYPhp/2S/Mxd+fnBz1/5/0cxl+s2Ve0+96O5/z8/nro/Hn44JdzuPyZ5NI6zr93ZpxPmuLvWvevc+vy/OOvzt63bfGyq422L1Ms3Y8Ojk/KdPT821ZpvhtvLJqn/WfrUzLMvvdtJ4nl8txqHXeuq3H9Rqeaj49fDtb7o3frS3HtI1qj79Y1/nXbL13tu+hjq1i9lzD1zT/jXnsXJb5vDe29Xzdq+1QeY7+32+207g/XPyschxO811f1lkb97Zut9H2thvbZuNvp+VYrWPluO3t1Wbz5xh+sFBbzNdr7+04e/zmz6cHr7VXsbm+Ox7Xu/z59vOL7TbZPMfMHjetd/O8un1dh99d87y087lHV3utWn/sdlu2wQXH1eTy5w94uww212f2uKl97/1x03+Vdd7cX77Zf3q72rn62P32ievvU5Vz9eZy7dv2G8fhzvVuHK/F7vUqZvPdfO5i13xr61xdpm/3scHm+o4iL/vqd+P349f8HBG93efH9ny5i3uxz/SGdZieo3eF8CKfh7SuS7kfbbz7gmXj+NmL/eqW22Bj26yf/PZ0iOe4Jfaf+8l228MNzqu3zfaLyXbpOW4OKus+dZ/Xy7Iv474u+633eQGRrT4GVTqoOrnoeIbg5qOVPHo01CGevLtiPzGHeA7gYRs/Yj917jj/2qecgltiuwCkJbzgQVuNW1w+gbRx4zp0JrneMzZRrNfCXW87HeI5gCvJdl4dO2Ccn0emL+eTBWXbLq5HAC4ILwAAAIDQhBcAAABAaI/Oy2fRZr5+/do9fvz4Yjq7h7SuS3mIbWy/0gY3oe3uJ9vtfrP9YrJdYruP2yfrPnWf18uyL+M+Lns1vAAAAABYmrIRAAAAILTqJy/Ozs6G/zM7Pj4epwAAAICImuFF5pt7JTIAAAAQn7IRAAAAIDThBQAAABCa8AIAAAAIrdrnRZnOTp8XAAAAEFs1vAAAAABYmrIRAAAAILTmUKnZZR4KFgAAADJohheZb+6VyAAAAEB8ykYAAACA0IQXAAAAQGjCCwAAACC0ap8XZTo7fV4AAABAbNXwAgAAAGBpykYAAACA0JpDpWaXeShYAAAAyKAZXmS+uVciAwAAAPEpGwEAAABCE14AAAAAoQkvAAAAgNCqfV6U6ez0eQEAAACxVcMLAAAAgKUpGwEAAABCaw6Vml3moWABAAAgg2Z4kfnmXokMAAAAxKdsBAAAAAhNeAEAAACEJrwAAAAAQqv2eVGms9PnBQAAAMRWDS8AAAAAlqZsBAAAAAitOVRqdpmHggUAAIAMmuFF5pt7JTIAAAAQn7IRAAAAIDThBQAAABCa8AIAAAAIrdrnRZnOTp8XAAAAEFs1vAAAAABYmrIRAAAAILTmUKnZZR4KFgAAADJohheZb+6VyAAAAEB8ykYAAACA0IQXAAAAQGjCCwAAACC0ap8XZTo7fV4AAABAbNXwAgAAAGBpykYAAACA0JpDpWaXeShYAAAAyKAZXmS+uVciAwAAAPEpGwEAAABCE14AAAAAoQkvAAAAgNCqfV6U6ez0eQEAAACxVcMLAAAAgKUpGwEAAABCaw6Vml3moWABAAAgg2Z4kfnmXokMAAAAxKdsBAAAAAhNeAEAAACEJrwAAAAAQqv2eVGms9PnBQAAAMRWDS8AAAAAlqZsBAAAAAitOVRqdpmHggUAAIAMmuFF5pt7JTIAAAAQn7IRAAAAIDThBQAAABCa8AIAAAAIrdrnRZnOTp8XAAAAEFs1vAAAAABYmrIRAAAAILTmUKnZZR4KFgAAADJohheZb+6VyAAAAEB8ykYAAACA0IQXAAAAQGjCCwAAACC0ap8XZTo7fV4AAABAbNXwAgAAAGBpykYAAACA0JpDpWaXeShYAAAAyKAZXmS+uVciAwAAAPEpGwEAAABCE14AAAAAoQkvAAAAgNCqfV6U6ez0eQEAAACxVcMLAAAAgKUpGwEAAABCaw6Vml3moWABAAAgg2Z4kfnmXokMAAAAxKdsBAAAAAhNeAEAAACEJrwAAAAAQqv2eVGms9PnBQAAAMRWDS8AAAAAlqZsBAAAAAitOVRqdpmHggUAAIAMmuFF5pt7JTIAAAAQn7IRAAAAIDThBQAAABCa8AIAAAAIrdrnRZnOTp8XAAAAEFs1vAAAAABYmrIRAAAAILTmUKnZZR4KFgAAADJohheZb+6VyAAAAEB8ykYAAACA0IQXAAAAQGjCCwAAACC0ap8XZTo7fV4AAABAbNXwAgAAAGBpykYAAACA0JpDpWaXeShYAAAAyKAZXmS+uVciAwAAAPEpGwEAAABCE14AAAAAoQkvAAAAgNCqfV6U6ez0eQEAAACxVcMLAAAAgKUpGwEAAABCaw6Vml3moWABAAAgg2Z4kfnmXokMAAAAxKdsBAAAAAhNeAEAAACEJrwAAAAAQqv2eVGms9PnBQAAAMRWDS8AAAAAlqZsBAAAAAitOVRqdpmHggUAAIAMmuFF5pt7JTIAAAAQn7IRAAAAIDThBQAAABCa8AIAAAAIrdrnRZnOTp8XAAAAEFs1vAAAAABYmrIRAAAAILTmUKnZZR4KFgAAADJohheZb+6VyAAAAEB8ykYAAACA0IQXAAAAQGjCCwAAACC0ap8XZTo7fV4AAABAbNXwAgAAAGBpykYAAACA0JpDpWaXeShYAAAAyKAZXmS+uVciAwAAAPEpGwEAAABCE14AAAAAoQkvAAAAgNCqfV6U6ez0eQEAAACxVcMLAAAAgKUpGwEAAABCaw6Vml3moWABAAAgg2Z4kfnmXokMAAAAxKdsBAAAAAhNeAEAAACEJrwAAAAAQqv2eVGms9PnBQAAAMRWDS8AAAAAlqZsBAAAAAitOVRqdpmHggUAAIAMmuFF5pt7JTIAAAAQn7IRAAAAIDThBQAAABCa8AIAAAAIrdrnRZnOTp8XAAAAEFs1vAAAAABYmrIRAAAAILTmUKnZZR4KFgAAADJohheZb+6VyAAAAEB8ykYAAACA0IQXAAAAQGjCCwAAACC0ap8XZTo7fV4AAABAbNXwAgAAAGBpykYAAACA0JpDpWaXeShYAAAAyKAZXmS+uVciAwAAAPEpGwEAAABCE14AAAAAoQkvAAAAgNCqfV6U6ez0eQEAAACxVcMLAAAAgKUpGwEAAABCaw6Vml3moWABAAAgg2Z4kfnmXokMAAAAxKdsBAAAAAhNeAEAAACEJrwAAAAAQqv2eVGms9PnBQAAAMRWDS8AAAAAlqZsBAAAAAitOVRqdpmHggUAAIAMmuFF5pt7JTIAAAAQn7IRAAAAIDThBQAAABCa8AIAAAAIrdrnRZnOTp8XAAAAEFs1vAAAAABYmrIRAAAAILTmUKnZZR4KFgAAADJohheZb+6VyAAAAEB8ykYAAACA0IQXAAAAQGjCCwAAACC0ap8XZTo7fV4AAABAbNXwAgAAAGBpykYAAACA0JpDpWaXeShYAAAAyKAZXmS+uVciAwAAAPEpGwEAAABCE14AAAAAoQkvAAAAgNCqfV6U6ez0eQEAAACxVcMLAAAAgKUpGwEAAABCaw6Vml3moWABAAAgg2Z4kfnmXokMAAAAxKdsBAAAAAhNeAEAAACEJrwAAAAAQhNeAAAAAKEJLwAAAIDQhBcAAABAaMILAAAAIDThBQAAABCa8AIAAAAITXgBAAAAhCa8AAAAAEITXgAAAAChCS8AAACA0IQXAAAAQGjCCwAAACA04QUAAAAQmvACAAAACE14AQAAAIT26Lw3Tg++fv3aPX78+GI6u2ldAQAAgJiq4QUAAADA0pSNAAAAAKFVP3lxdnY2/J/Z8fHxOAUAAABE1AwvMt/cK5EBAACA+JSNAAAAAKEJLwAAAIDQhBcAAABAaNU+L8p0dvq8AAAAgNiq4QUAAADA0pSNAAAAAKE1h0rNLvNQsAAAAJBBM7zIfHOvRAYAAADiUzYCAAAAhCa8AAAAAEITXgAAAAChVfu8KNPZ6fMCAAAAYquGFwAAAABLUzYCAAAAhNYcKjW7zEPBAgAAQAbN8CLzzb0SGQAAAIhP2QgAAAAQmvACAAAACE14AQAAAIRW7fOiTGenzwsAAACIrRpeAAAAACxN2QgAAAAQWnOo1OwyDwULAAAAGTTDi8w390pkAAAAID5lIwAAAEBowgsAAAAgNOEFAAAAEFq1z4synZ0+LwAAACC2angBAAAAsDRlIwAAAEBozaFSs8s8FCwAAABk0AwvMt/cK5EBAACA+JSNAAAAAKEJLwAAAIDQhBcAAABAaNU+L8p0dvq8AAAAgNiq4QUAAADA0pSNAAAAAKE1h0rNLvNQsAAAAJBBM7zIfHOvRAYAAADiUzYCAAAAhCa8AAAAAEITXgAAAAChVfu8KNPZ6fMCAAAAYquGFwAAAABLUzYCAAAAhNYcKjW7zEPBAgAAQAbN8CLzzb0SGQAAAIhP2QgAAAAQmvACAAAACE14AQAAAIRW7fOiTGenzwsAAACIrRpeAAAAACxN2QgAAAAQWnOo1OwyDwULAAAAGTTDi8w390pkAAAAID5lIwAAAEBowgsAAAAgNOEFAAAAEFq1z4synZ0+LwAAACC2angBAAAAsDRlIwAAAEBozaFSs8s8FCwAAABk0AwvMt/cK5EBAACA+JSNAAAAAKEJLwAAAIDQhBcAAABAaNU+L8p0dvq8AAAAgNiq4QUAAADA0pSNAAAAAKE1h0rNLvNQsAAAAJBBM7zIfHOvRAYAAADiUzYCAAAAhCa8AAAAAEITXgAAAAChVfu8KNPZ6fMCAAAAYquGFwAAAABLUzYCAAAAhNYcKjW7zEPBAgAAQAbN8CLzzb0SGQAAAIhP2QgAAAAQmvACAAAACE14AQAAAIRW7fOiTGenzwsAAACIrRpeAAAAACxN2QgAAAAQWnOo1OwyDwULAAAAGTTDi8w390pkAAAAID5lIwAAAEBowgsAAAAgNOEFAAAAEFq1z4synZ0+LwAAACC2angBAAAAsDRlIwAAAEBozaFSs8s8FCwAAABk0AwvMt/cK5EBAACA+JSNAAAAAKEJLwAAAIDQhBcAAABAaNU+L8p0dvq8AAAAgNiq4QUAAADA0pSNAAAAAKE1h0rNLvNQsAAAAJBBM7zIfHOvRAYAAADiUzYCAAAAhCa8AAAAAEITXgAAAAChVfu8KNPZ6fMCAAAAYquGFwAAAABLUzYCAAAAhNYcKjW7zEPBAgAAQAbN8CLzzb0SGQAAAIhP2QgAAAAQmvACAAAACE14AQAAAIRW7fOiTGenzwsAAACIrRpeAAAAACxN2QgAAAAQWnOo1OwyDwULAAAAGTTDi8w390pkAAAAID5lIwAAAEBowgsAAAAgNOEFAAAAEFq1z4synZ0+LwAAACC2angBAAAAsDRlIwAAAEBozaFSs8s8FCwAAABk0AwvMt/cK5EBAACA+JSNAAAAAKEJLwAAAIDQhBcAAABAaNU+L8p0dvq8AAAAgNiq4QUAAADA0pSNAAAAAKE1h0rNLvNQsAAAAJBBM7zIfHOvRAYAAADiUzYCAAAAhCa8AAAAAEITXgAAAAChVfu8KNPZ6fMCAAAAYquGFwAAAABLUzYCAAAAhNYcKjW7zEPBAgAAQAbN8CLzzb0SGQAAAIhP2QgAAAAQmvACAAAACE14AQAAAIRW7fOiTGenzwsAAACIrRpeAAAAACxN2QgAAAAQWnOo1OwyDwULAAAAGTTDi8w390pkAAAAID5lIwAAAEBowgsAAAAgNOEFAAAAEFq1z4synZ0+LwAAACC2angBAAAAsDRlIwAAAEBozaFSs8s8FCwAAABk0AwvMt/cK5EBAACA+JSNAAAAAKEJLwAAAIDQhBcAAABAaNU+L8p0dvq8AAAAgNiq4QUAAADA0pSNAAAAAKE1h0rNLvNQsAAAAJBBM7zIfHOvRAYAAADiUzYCAAAAhCa8AAAAAEITXgAAAAChVfu8KNPZ6fMCAAAAYquGFwAAAABLUzYCAAAAhNYcKjW7zEPBAgAAQAbN8CLzzb0SGQAAAIhP2QgAAAAQmvACAAAACE14AQAAAIRW7fOiTGenzwsAAACIrRpeAAAAACxN2QgAAAAQWnOo1OwyDwULAAAAGTTDi8w390pkAAAAID5lIwAAAEBowgsAAAAgNOEFAAAAEFq1z4synZ0+LwAAACC2angBAAAAsDRlIwAAAEBozaFSs8s8FCwAAABk0AwvMt/cK5EBAACA+JSNAAAAAKEJLwAAAIDQhBcAAABAaMILAAAAIDThBQAAABCa8AIAAAAITXgBAAAAhCa8AAAAAEITXgAAAAChPTrvjdODr1+/do8fP76Yzm5aVwAAACCmangBAAAAsDRlIwAAAEBo33zy4uzsbJwCAAAAWN434QUAAABAJMpGAAAAgNCEFwAAAEBowgsAAAAgNOEFAAAAEJrwAgAAAAis6/4fw/EYzdlD7S0AAAAASUVORK5CYII=

    Excellent header, but strange rows.....
    Thanks!
    Ken
    kbaker20@humana.com

    Would be keen to see the table and some sample data.  May have missed something.  Whilst no help to you, it works for the example we threw at it 🙂

  • I am having the same issue


    Here is the data for your review

    name    User_Login    enabled    date_created    date_modified    step_id    step_name    command
    Modification Test    US\mar1jxm    1    2018-03-12 11:25:16.573    2018-03-13 17:06:26.183    1    Step 1    Select 50 +30 +10
    Modification Test    US\mar1jxm    1    2018-03-12 11:25:16.573    2018-03-13 17:06:26.183    2    Step 2 Insert    Select 60
    Modification Test    US\mar1jxm    1    2018-03-12 11:25:16.573    2018-03-13 17:06:26.183    3    Step 3    Select 114


    Jacob Milter

  • mar1jxm - Wednesday, March 14, 2018 7:53 AM

    I am having the same issue


    Here is the data for your review

    name    User_Login    enabled    date_created    date_modified    step_id    step_name    command
    Modification Test    US\mar1jxm    1    2018-03-12 11:25:16.573    2018-03-13 17:06:26.183    1    Step 1    Select 50 +30 +10
    Modification Test    US\mar1jxm    1    2018-03-12 11:25:16.573    2018-03-13 17:06:26.183    2    Step 2 Insert    Select 60
    Modification Test    US\mar1jxm    1    2018-03-12 11:25:16.573    2018-03-13 17:06:26.183    3    Step 3    Select 114

    Can you supply the table definition? As it work for me.


    CREATE TABLE emailtest
      (
       Name NVARCHAR(100) ,
       User_Login NVARCHAR(100) ,
       enabled BIT ,
       date_created DATETIME2 ,
       date_modified DATETIME2 ,
       step_id INT ,
       step_name NVARCHAR(100) ,
       command NVARCHAR(MAX)
      )

    INSERT INTO emailtest ( Name ,
            User_Login ,
            enabled ,
            date_created ,
            date_modified ,
            step_id ,
            step_name ,
            command )
    VALUES
    ('Modification Test', 'US\mar1jxm', 1, '2018-03-12 11:25:16.573', '2018-03-13 17:06:26.183', 1 ,'Step 1', 'Select 50 +30 +10'),
    ('Modification Test','US\mar1jxm', 1, '2018-03-12 11:25:16.573', '2018-03-13 17:06:26.183', 2, 'Step 2', 'Insert Select 60'),
    ('Modification Test', 'US\mar1jxm', 1, '2018-03-12 11:25:16.573', '2018-03-13 17:06:26.183', 3, 'Step 3', 'Select 114' )

    DECLARE @GeneratedHTML NVARCHAR(MAX);
    EXEC dbo.sp_GenerateHTMLTableResults @ResultsTableName = N'dbo.emailtest' ,     -- nvarchar(100)
                   @GeneratedHTML = @GeneratedHTML OUTPUT -- nvarchar(max)

    PRINT @GeneratedHTML

  • Thank you very much for your reply.
    I ran your script AS IS and got the same result.
    Any ideas?


    Jacob Milter


  • Hi again!
    As a test I created a html file and opened it in IE.
    Same result!


    Jacob Milter

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply