How can I use a select statement in conjuction with a stored procedure

Question

How can I achieve something like this :

SELECT * DISTINCT FROM 
(execute dbo.MyStoredProcedure(@ID1,@ID2))

suppose that's inside another stored procedure.

How can I call a stored procedure from another stored procedure and get the result as a table (my select is intended for that)

have you considered searching? : http://stackoverflow.com/questions/1492411/sql-server-select-from-stored-procedure — Mitch Wheat, Mar 03 '13 at 08:45

score 2 · Accepted Answer · answered Mar 03 '13 at 08:47

2

Try

DECLARE @TableTemp TABLE (--declare parameters, ouput from SP)

INSERT INTO @TableTemp
EXEC dbo.MyStoredProcedure @ID1,@ID2

SELECT * FROM @TableTemp

answered Mar 03 '13 at 08:47

Conrad Lotz

score 1 · Answer 2 · edited Mar 03 '13 at 10:05

1

You can do something like this.

INSERT INTO #temp 
EXEC MyStoredProcedure(@ID1,@ID2)

SELECT * FROM #temp

edited Mar 03 '13 at 10:05

marc_s

answered Mar 03 '13 at 08:52

Praveen Nambiar

2 Answers2