topic Re: Import Data from Stored Procedure in SQL Server in Discussions

Import Data from Stored Procedure in SQL Server

mende001 — Fri, 09 Jun 2023 16:11:08 GMT

Hello,

I have been trying to import data from a stored procedure but it returns nothing. Anytime I try to use the "Open Table" window, it returns this error message. I have used both JMP 15 and JMP 17.

When attempting to use a script to pull the data, nothing is returned and no error message pops up. Script is below:

Connection String = Create Database Connection(
"DRIVER=SQL Server;Server=Example Server;Trusted_Connection=Yes;APP=JMP;DATABASE=Example DB;");

I guess my questions are what is the best way to import data from a stored procedure in a SQL Server and what is the best route for this scenario in particular?

Thank you!

Re: Import Data from Stored Procedure in SQL Server

pmroz — Thu, 01 Jun 2023 11:49:03 GMT

You can't import data from a stored procedure in Oracle. I expect the same to be true for SQL server but I defer to experts.

Perhaps could run your procedure to create a table, and then issue a SELECT * from that table with a separate execute SQL command?

If that doesn't work you could try JMP tech support.

Re: Import Data from Stored Procedure in SQL Server

guillaumebugnon — Fri, 02 Jun 2023 14:06:31 GMT

Hello,

Maybe try to execute this : "EXEC storeprocedurename".

As described here: Execute a Stored Procedure - SQL Server | Microsoft Learn

Regards,

Guillaume