UNION the results of multiple stored procedures

by

You’d have to use a temp table like this. UNION is for SELECTs, not stored procs

CREATE TABLE #foo (bar int ...)

INSERT #foo
exec MyStoredProcedure 1

INSERT #foo
exec MyStoredProcedure 2

INSERT #foo
exec MyStoredProcedure 3

...

And hope the stored procs don’t have INSERT..EXEC.. already which can not be nested. Or multiple resultsets. Or several other breaking constructs

More Related Contents:

  1. Insert results of a stored procedure into a temporary table
  2. How to SELECT FROM stored procedure
  3. Function vs. Stored Procedure in SQL Server
  4. SQL Server – How to lock a table until a stored procedure finishes
  5. Stored procedure or function expects parameter which is not supplied
  6. What is a stored procedure?
  7. How to assign an exec result to a sql variable?
  8. Search text in stored procedure in SQL Server
  9. SQL Call Stored Procedure for each Row without using a cursor
  10. SQL Server SELECT into existing table
  11. How do I execute a stored procedure once for each row returned by query?
  12. How to check if a stored procedure exists before creating it
  13. Execute Stored Procedure from a Function
  14. SQL : in clause in stored procedure:how to pass values
  15. SQL Server UNION – What is the default ORDER BY Behaviour
  16. How to return the output of stored procedure into a variable in sql server
  17. SQL Server silently truncates varchar’s in stored procedures
  18. Split values over multiple rows [duplicate]
  19. How do I pass a list as a parameter in a stored procedure?
  20. Must declare the scalar variable
  21. Why execute stored procedures is faster than SQL query from a script?
  22. Stored procedure that exports data into csv files only exports to one file
  23. Custom Date/Time formatting in SQL Server
  24. Insert Update stored proc on SQL Server
  25. SQL Server: should I use information_schema tables over sys tables?
  26. Inserting rows into a table with one IDENTITY column only [duplicate]
  27. How to pass a temp table as a parameter into a separate stored procedure
  28. Eliminate and reduce overlapping date ranges
  29. Dynamic order direction
  30. How do I execute a MS SQL Server stored procedure in java/jsp, returning table data?

Leave a Comment