Given a stored procedure on MS SQL Server, if I execute it using SQLSRV and CodeIgniter, I can see that the stored procedure executes and modifies data.
However, if I run a select statement inside the procedure, SQLSRV doesn't return any data. How can I fix this?