Thanks again..

If the proc (sp_test) has multiple select queries..then what happens to the result set handling as by above scenario?? ( Also is multiple SELECT query case is used in...

Thanks friends for the quick response.

If i've a simple proc like this

CREATE PROCEDURE sp_test

AS

BEGIN

SELECT * FROM EMPLOYEE

END

and when i called the PROC within a procedure , is there any possibility...