Build HTML Email from SQL Table content.

There was a need to create HTML table email body from the contents in the SQL table.

Here is the code snippet to do it.

 

 

Set @body = select

                                         AgencyID AS [TD]

                                    , Name AS [TD]

                                    , IsClient AS [TD]

                           from data.Agencies

                           For XML raw('tr'), Elements

 

I must give credit for the following site which provided this idea and good explanation.

 

http://www.sqlservercentral.com/blogs/robert_davis/2010/06/15/Building-HTML-Emails-With-SQL-Server-and-XML/

 

Happy Coding.

 

Cheers

Adam