I would like to create a string from a simple select clause building an html table with the database rows...
I tried something like this but it didn't add multiple rows:
DECLARE @strHTML varchar(5000)
SET @strHTML = '<html><body><table>'
SELECT '<tr><td>'+NavPass+'</td><td>'+email+'</td></tr>' as strH FROM tblUser
SET @strHTML = @strHTML + '</table></body></html>'
can someone figure out how to have the return dataset encapsulated in an HTML table?