i have a stored procedure which outputs data from various table query like below.
create procedure ki_data
select * from customer
select * from order
select * from invoices
i would like to send the output of stored procedure (in text format) to email .
I know how i can do it using select statement
@subject = 'Duplicate PO Lot',
@query = 'SELECT lot, ref_num, ref_line_suf FROM phil_App.dbo.ki_po_dup_lot WHERE prev_lot_used = lot
@body = 'Dulicate PO Lot',
@attach_query_result_as_file = 1 ;
How do i replace select statement to stored procedure.
- This topic was modified 1 month ago by skb 44459.