Access issue

D

DiLwALi

Hi
I am currently using a pass-through query to run a SQL stored procedure
- is there a way for me to create a 'make table' query to run the SQL
stored procedure and create a table with the results.

Thanks
 
C

Chris M

Hi
I am currently using a pass-through query to run a SQL stored procedure
- is there a way for me to create a 'make table' query to run the SQL
stored procedure and create a table with the results.

Thanks
Click to expand...

You mean a SINGLE query that both returns the result AND creates a table
containing the results. I don't think a MAKETABLE query can return a
resultset. As far as I know, you will have to run two seperate queries to
acomplish that.

One to run the MAKETABLE query and one to return the contents of the newly
created table.

Chris.
 
Top