Access issue

  • Thread starter Thread starter DiLwALi
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Call stored procedure in SSMS from Access 2016 doesn't work. 0
Question on Pass-through Query 4
stored procedure query 4
What are the steps to fix damaged MDF files in SQL Server? 0
SQL Server 5
Pass Through Query - not returning rows 1
SQL server backend 2
SQL Stored Procedure 1

Back
Top