Hi.

I'm trying to output results of my stored procedure to an Excel file
and calling this from a batch file to run regularly.

I'm using:
Adaptive Server Enterprise/15.0.3/EBF 16738 ESD#2/P/NT(IX86)/Windows
2003/ase1503/2708/32-bit/OPT/Mon Jul 27
20:19:56 2009

Interactive SQL version 11.0.0 build 1649

Here's my code:

myprocedure.sql :
create procedure dbo.myprocedure()
as
begin
create table #temptable ( myid varchar(10), lname varchar(10),
fname varchar(10) )
insert into #temptable values('1234567890','Smith','John')
select * from #temptable
end

runreport.sql : exec myprocedure ; output to 'myreport.xls' format
html ;

runreport.bat : dbisql -nogui -c "uid=reportuser;pwd=reportuser" -host
myserver -port 5000 read runreport.sql

If I run the sql file in the Interactive SQL GUI, it outputs the excel
file perfectly. But when I run it using the command line dbisql, it
outputs just the headers, no data into the output 'myreport.xls' file.
The data is echoed to screen when -q option is not selected.

This only happens when I use temporary tables for my output. If I just
run a simple select on an existing database table, the output contains
headers & data.

Any suggestions?

Thanks.