call a procedure

[immad]

i have a procedure name query


i want to make a procedure name proc and call this query procedure inside this procedure

 

[bborissov]

Bad naming

CREATE PROCEDURE MyProc
AS
BEGIN
   CALL [Query]
END

If [QUERY] is placed in another Database you should use full anme of the proc:
DBName.schema.ProcedureName

Borislav Borissov
VFP9 SP2, SQL Server

 

[yelworcm]

I don't know if CALL is a SQL Server function, or not. But this should work;

create procedure test2
as
select getdate()
go

create procedure test1
as
exec test2
go

test1

 

[bborissov]

My mistake, it is EXEC not CALL

CREATE PROCEDURE MyProc
AS
BEGIN
   [COLOR=red]EXEC[/color] [Query]
END

Borislav Borissov
VFP9 SP2, SQL Server

 

[1DMF]

and if you want to execute an SP within another SP and use the returned results in a join, you can use a temp table..

BEGIN
	CREATE TABLE #TEMP (   
		ID int,
		Name varchar(30),
		Tel varchar(12)
    )

	INSERT INTO #TEMP (ID, Name, Tel)   
	EXEC dbo.spGetPeople


	SELECT Name, Tel, Address, PostCode
         FROM Addresses a 
         JOIN #TEMP t ON a.ID = t.ID

	DROP TABLE #TEMP
END

"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Free Dance Music Downloads