Dec 16 2005, 12:58 PM
Can I use a pass through to execute a stored procedure?
How can I retrieve a resultant set from that stored procedure and put it in a make table?
Dec 16 2005, 12:59 PM
I'm looking at a remote SQL Server database and the processing is extensive. I just want the resultant for
further "What if" analysis.
Dec 16 2005, 01:07 PM
To execute a sp:
Create a pass thru with something like this
To use a pass thru to creat make table:
Use the pass thru as the source for the the make table
Dec 16 2005, 03:12 PM
Exec TQS_RepClaims 'Met', '11/1/2005', '11/30/2005'
I have the above in query Q1 - it has return row = yes.
When I use make table Q2 (Q1 as source) and try to execute, I get the window 'Select Data Source ODBC' Screen.
If I manually select DSN CL_DevClaims I get the make table I want.
Let the query know where to look for TQS_Repclaims?
I have tried [CL_Devclaims].[TQS_RepClaims] and [CL_Devclaims].dbo.[TQS_RepClaims]
with out success.
Dec 16 2005, 04:35 PM
Are you wanting to make the table on the local mdb or on the SQL Server?
Is the connection string stored with the query?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here