EXECUTE AN STOREDPROCEDURE IN ANOTHER STOREDPROCEDURE

Hi Reza, you should note this newsgroup is for spanish messages, not
english.

You should try microsoft.public.sqlserver instead.

Gustavo Larriera, MVP-SQL, MCSE
Uruguay LatAm
Este mensaje se proporciona "COMO ESTA" sin garantias y no otorga ningun
derecho / This posting is provided "AS IS" with no warranties, and confers
no rights.
"Reza Alirezaei" wrote in message
news:%239r9$

How can I excute an storedprocedure within another storedprocedure,I am
going to so do someting like this:



CREATE PROCEDURE dbo.usp_test
(
@panelfilterid varchar(60) = null

)
AS
SET NOCOUNT ON
IF( @panelfilterid IS NULL)

SELECT * FROM (EXECUTE SP_TEST @panelfilterid)

ELSE
SLECT * FROM STUDY

RETURN
GO


*NOTE) SP_TEST RETURNS A RESULTSET


any help will be appriciated.
Reza

insert into temptable exec Sp_test
No es una buena idea llamar a los procedimientos almacenados sp_XXX

Saludos

Saludos

Miguel Egea
Microsoft SQL-SERVER MVP
Brigada Anti-Cursores
http://www.portalsql.com

(Quita el online si me tienes que mandar un correo)


"Reza Alirezaei" escribió en el
mensaje news:#9r9$

How can I excute an storedprocedure within another storedprocedure,I am
going to so do someting like this:



CREATE PROCEDURE dbo.usp_test
(
@panelfilterid varchar(60) = null

)
AS
SET NOCOUNT ON
IF( @panelfilterid IS NULL)

SELECT * FROM (EXECUTE SP_TEST @panelfilterid)

ELSE
SLECT * FROM STUDY

RETURN
GO


*NOTE) SP_TEST RETURNS A RESULTSET


any help will be appriciated.
Reza