Sql – How should I get stored procedure result set in sql server 2005


I have a stored procedure that named globalsearch. the stored procedure return some results. the problem is how should I get results that is returned stored procedure in sql server 2005.thanks!

Best Solution

If you're asking how to get the result of a procedure from another procedure, the only way is to capture it into a table insert. See this article on MSDN covering the subject in detail: Getting Creative with EXEC.