Assistance needed urgently!
I use a Sybase Database with SQL Anywhere 9 and need to send the SQL query result as the body of the e-mail from within SQL. Here's what I have thusfar:
=============== =============== =============== ===== =====
bEGIN
SET NOCOUNT ON
select distinct
CLient from Client;
IF @@ROWCOUNT > 0
BEGIN
DECLARE @body...
The Programmer
Last Activity: Apr 11 '06, 06:26 AM
Joined: Apr 10 '06
Location: South Africa
-
Sending SQL query result as Email body.
-
Sending SQL query result as email body
Assistance needed urgently!
I use a Sybase Database with SQL Anywhere 9 and need to send the SQL query result as the body of the e-mail from within SQL. Here's what I have thusfar:
=============== =============== =============== ==========
bEGIN
SET NOCOUNT ON
select distinct
CLient from Client;
IF @@ROWCOUNT > 0
BEGIN
...
No activity results to display