SP Send Query Result as HTML table using DBMail
Create a stored procedure that will send the result of a query as an html table from the database mail.
2015-03-26 (first published: 2014-02-14)
4,465 reads
Create a stored procedure that will send the result of a query as an html table from the database mail.
2015-03-26 (first published: 2014-02-14)
4,465 reads
sum( case dbo.D_VEHICLE_STATUS.LIFECYCLE_STATUS_CODE when '0' then dbo.F_VEHICLE_STATUS.VEHICLE_STATUS_UNITS else sum( ( case when dbo.D_PORT.PHYSICAL_PORT_CODE = 'PMA' then dbo.F_VEHICLE_STATUS.VEHICLE_STATUS_UNITS else 0 end ) end ) every case must have a end.
2004-03-19
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers