I am using Database Mail, (SQL Server 2005) and would trying to do use the @query function.
1. When an invoice is saved to SQL database
2. A trigger sends an email
3. I have captured the invoice number and tracking number but would also like to capture the details of the invoice line items: Item Number, qty. This information is in a different table than the trigger.
Will this be possible? and if so any suggestions?
Doug
