This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
I have a stored procedure that dynamically creates a SQL statement which contains a pivot and then uses an execute to run the created sql. If i run this in management studio then I correctly get back the result of the SQL statement. However when I add the stored procedure to Lightspeed the return type is a int. Is there a way I can get lightspeed to bring back the resulting data from the execute statement. ` |
|
|
|
|
Have you tried executing this using UnitOfWork.Project(ProcedureQuery)?
|
|
|
|
