This is an interesting and useful article that explains how to convert sql query results to html format
http://www.sqlservercentral.com/blogs/robert_davis/archive/2010/06/15/Bu...
Thanks to the author Robert