I have a crystal report that also has a subreport inside it and the report is running really slow.

I wondered if I can create 2 temporary tables within the main report, left outer join the 2 and go that route instead of the route I've taken.

The problem is I only have read-only access to the database and I wondered if I can create these temporary tables outside of a stored procedure.

Basically I need to know if I can do what I need in a command. Any examples would be greatly appreciated.

Thanks!