About EasyMorph Tutorials & Examples Web-help

MSSQL Data From Stored Procedure [DONE]


#1

It would be fantastic to have the facility to fetch data from stored procedure directly in EasyMorph.

At present, I am having to create a series of holding tables for the data from the executed stored procedure.


#2

Hi Daniel,

you can fetch data directly from stored procedures using custom SQL in queries. See below:

More than that – it is possible to use EasyMorph project parameters to specify arguments of stored procedures. For example, in the statement above, the argument could be passed via a project parameter.

EXEC dbo.uspGetEmployeeManagers {ParamID};