Import Data from Stored Procedure in SQL Server

[#1]

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;");

<Execute SQL( Connection String, "EXECUTE StoredProcedure @ColumnName = 'example' ", "data table");>

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!

[#2]

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.

[#3]

Hello,

Maybe try to execute this : "EXEC storeprocedurename".

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

Regards,

Guillaume