Hi folks,

I've gotten better with the sendmail token. I can pull table data to write into an email now. This is awesome! One thing I need to be able to do is pull table data and write into an email in the form of columns and rows. [sqlquery] token returns only one value at a time. I can pull more data and write for XML, for example:

[sqlquery: select descript + ', ' + markup + ', ' AS [data()] FROM materials where jobid = '5' FOR XML PATH('')]

This will return comma delimited data. Is there another way to use XML within SQL query to produce a table output format with columns and rows?

This would help tremendously. Thanks for your thoughts, they are most appreciated!

Brandon