hi,guys: 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!
+1
A:
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.
Remus Rusanu
2009-07-15 05:25:27