How to SELECT FROM stored procedure

by

You can

  1. create a table variable to hold the
    result set from the stored proc and
    then
  2. insert the output of the
    stored proc into the table variable,
    and then
  3. use the table variable
    exactly as you would any other
    table…

… sql ….

Declare @T Table ([column definitions here])
Insert @T Exec storedProcname params 
Select * from @T Where ...

More Related Contents:

  1. Insert results of a stored procedure into a temporary table
  2. Execute Stored Procedure from a Function
  3. SQL : in clause in stored procedure:how to pass values
  4. Eliminate and reduce overlapping date ranges
  5. Is it possible to write single query on two table which are not connected to each other?
  6. How to update two tables in one statement in SQL Server 2005?
  7. SQL query to select dates between two dates
  8. How to avoid the “divide by zero” error in SQL?
  9. Function vs. Stored Procedure in SQL Server
  10. Selecting COUNT(*) with DISTINCT
  11. Querying data by joining two tables in two database on different servers
  12. Generate a resultset of incrementing dates in TSQL
  13. Real life example, when to use OUTER / CROSS APPLY in SQL
  14. Better techniques for trimming leading zeros in SQL Server?
  15. SQL Server – How to lock a table until a stored procedure finishes
  16. What’s the best way to select the minimum value from several columns?
  17. Search text in stored procedure in SQL Server
  18. How to check if a stored procedure exists before creating it
  19. How to return the output of stored procedure into a variable in sql server
  20. How can I determine the status of a job?
  21. How to check which locks are held on a table
  22. Inserting rows into a table with one IDENTITY column only [duplicate]
  23. How to find sum of multiple columns in a table in SQL Server 2005?
  24. SQL Script to alter ALL Foreign Keys to add ON DELETE CASCADE
  25. Is it possible to execute a text file from SQL query?
  26. Query times out from web app but runs fine from management studio
  27. SQL Server 2005 – Export table programmatically (run a .sql file to rebuild it)
  28. SQL Sort Order with Null values last
  29. Insert all values of a table into another table in SQL
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment