Demo 1 - Email HTML | Demo
2 - Email PDF | Demo 3 - SQL to PDF | Demo
4 - Embedded Queries
Demo 5 - Prescheduled Queue | Demo
6 - Dynamic Queue | Demo 7 - Zip &
Password-Protect
Demo 8 - Mail Merge | Demo 9 -
Content Path | Demo 10 -
Excel Workbook | Demo 11 -
Word/RTF
Demo 1 - Sending multiple resultsets in HTML format
| Description |
This demo emails three resultsets from Northwind database in a single email.
The demo features the use of HTML, CSS, and images. Notice that HTML content is loaded from a URL specified in the
@content_path parameter. To run the demo, please
provide an email address to send the results to and click on the Run Demo 1
button. |
| Email |
|
| SQL Code |
exec sp_sendSAM @recipients= provided in form, @subject= 'Demo email from SqlAnswersMail', @content_path= 'http://www.sqlanswers.com/newsletters/MultiResultSet.htm', @format= 'html', @query= 'select top 3 ProductName, ProductPhoto, ''$''+convert(varchar(7), ProductPrice, 1) as Price from Northwind..Special;
select top 10 CustomerID, OrderDate, ShipName from Northwind..Orders;
select top 3 Photo, FirstName, LastName, Title, City, Region from Northwind..employees'
|