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

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? : stackoverflow.com/questions/1492411/… — Mitch Wheat
– Mitch Wheat, Commented Mar 3, 2013 at 8:45

Conrad Lotz · Accepted Answer · 2013-03-03 08:47:56Z

Try

DECLARE @TableTemp TABLE (--declare parameters, ouput from SP) INSERT INTO @TableTemp EXEC dbo.MyStoredProcedure @ID1,@ID2 SELECT * FROM @TableTemp

marc_s · Accepted Answer · 2013-03-03 10:05:11Z

1

You can do something like this.

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

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Mar 3, 2013 at 8:52

4,9022 gold badges24 silver badges32 bronze badges

2 Answers 2