SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


HTML Table Results For Email


HTML Table Results For Email

Author
Message
higgim
higgim
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3622 Visits: 2914
Comments posted to this topic are about the item HTML Table Results For Email
kbaker91
kbaker91
SSC Rookie
SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)

Group: General Forum Members
Points: 30 Visits: 58
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
ksiozios
ksiozios
SSC-Enthusiastic
SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)

Group: General Forum Members
Points: 137 Visits: 29
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 :-)
jbeard-1143697
jbeard-1143697
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 24
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 Smile

set @ColumnHeader
= '<table cellpadding="2" cellspacing="2" border="1" style="font-family: Arial; font-size: 8pt"><TR>'
+ @ColumnHeader + '</TR>';
hoolash
hoolash
SSC Eights!
SSC Eights! (976 reputation)SSC Eights! (976 reputation)SSC Eights! (976 reputation)SSC Eights! (976 reputation)SSC Eights! (976 reputation)SSC Eights! (976 reputation)SSC Eights! (976 reputation)SSC Eights! (976 reputation)

Group: General Forum Members
Points: 976 Visits: 89
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?
higgim
higgim
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3622 Visits: 2914
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?

higgim
higgim
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3622 Visits: 2914
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 Smile

mar1jxm
mar1jxm
SSC Eights!
SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)

Group: General Forum Members
Points: 965 Visits: 695
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
higgim
higgim
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3622 Visits: 2914
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

mar1jxm
mar1jxm
SSC Eights!
SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)

Group: General Forum Members
Points: 965 Visits: 695
Thank you very much for your reply.
I ran your script AS IS and got the same result.
Any ideas?



Jacob Milter
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search