Select columns from result set of stored procedure

by

Can you split up the query? Insert the stored proc results into a table variable or a temp table. Then, select the 2 columns from the table variable.

Declare @tablevar table(col1 col1Type,..
insert into @tablevar(col1,..) exec MyStoredProc 'param1', 'param2'

SELECT col1, col2 FROM @tablevar

More Related Contents:

  1. T-SQL stored procedure that accepts multiple Id values
  2. Escape a string in SQL Server so that it is safe to use in LIKE expression
  3. EXEC sp_executesql with multiple parameters
  4. T-SQL Dynamic SQL and Temp Tables
  5. How do I find a stored procedure containing ?
  6. Check if a string contains a substring in SQL Server 2005, using a stored procedure
  7. SQL Server stored procedure return code oddity
  8. Why can’t Entity Framework see my Stored Procedure’s column information?
  9. Understanding PIVOT function in T-SQL
  10. How do I escape a percentage sign in T-SQL?
  11. Using RegEx in SQL Server
  12. Parse JSON in TSQL
  13. Get size of all tables in database
  14. Fuzzy matching using T-SQL
  15. List of all index & index columns in SQL Server DB
  16. How much size “Null” value takes in SQL Server
  17. SQL Server: Isolation level leaks across pooled connections
  18. What is the difference between using a cross join and putting a comma between the two tables?
  19. How do I use the CONCAT function in SQL Server 2008 R2?
  20. Preserving ORDER BY in SELECT INTO
  21. Select / Insert version of an Upsert: is there a design pattern for high concurrency?
  22. How to add custom attributes to SQL connection string?
  23. Inserting rows into a table with one IDENTITY column only [duplicate]
  24. Compute MD5 hash of a UTF8 string
  25. LPAD in SQL Server 2008
  26. How to check SQL Server Database compatibility after sp_dbcmptlevel is deprecated?
  27. How do I remove non-breaking spaces from a column in SQL server?
  28. How to set value to variable using ‘execute’ in t-sql?
  29. Taking the second last row with only one select in SQL Server?
  30. Count number of records returned by group by

Leave a Comment