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
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2447 Visits: 2668
Comments posted to this topic are about the item HTML Table Results For Email
kbaker91
kbaker91
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 45
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 (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)

Group: General Forum Members
Points: 109 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
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 22
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
Right there with Babe
Right there with Babe (762 reputation)Right there with Babe (762 reputation)Right there with Babe (762 reputation)Right there with Babe (762 reputation)Right there with Babe (762 reputation)Right there with Babe (762 reputation)Right there with Babe (762 reputation)Right there with Babe (762 reputation)

Group: General Forum Members
Points: 762 Visits: 66
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
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2447 Visits: 2668
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
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2447 Visits: 2668
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

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