Unanswered: cursor on results from stored procedure?
I am working on a stored procedure that needs to pass through the results of another procedure, using a cursor. Any idea why this isn't working? The exec statement works fine when I try it on it's own.
DECLARE myCursor CURSOR
FOR (exec sp_splitstring @array = @searchstr, @separator = ' ')