I am trying to send a message using sp_send_dbmail that has several fields, and one field that I would like to make clickable. This is the code I am currently using that I would have thought would work.
select td = '<a href="http://www.somewebsite.com
">Login<a/>' + reportnumber from sometable for xml PATH('tr')
The problem is the link works fine, but is displayed as "http://www.somewebsite.com
" instead of just "Login" as the code would suggest. The actual link I am using is far longer than that making the report unreadable unless I can shorten it down to just "Login" as it should act.
I do have the @body_format = 'HTML' set correctly...