Firstly, thanks J Livingston for your excellent example. I was able to modify it for my use.
SSISDeveloper189155 (9/17/2014)
So the SQL Query within the code , the current code doesn't seem to execute the SQL to get some result out of the SQL , how do we fix this?
189155, the code worked fine for me. I replaced the td = parts with my column names, adjusted the rest of the query appropriately, and then updated the N' sections above the query with HTML that suited my taste. Also keep in mind that the table-header sections <th> need to be updated to match the columns you assign to the td items in the SELECT.