I have a procedure having three select statements where it gives the output through DB mail of 3 results in excel format. client asked to get the results named. like query1results for first select statement, query2results for the second select statement, query3results for the third select statement.
please suggest how i can give names to the results in procedure. procedure code is like this:
alter procedure employee
select empid,salarydetails from employee
select empid,empname from employee
select empname,storedetails from employee