Execute A Stored Procedures from a Query

[JVZ]

Hello All -

I was wondering if the below query is possible?

SELECT tDate, rCount
FROM (EXEC usp_someSP)
GROUP BY tDate

 

[ClaireHCM]

Unfortunately, not possible.

But if you could combine the logic of the query alone with the stored procedure to make another stored procedure is also not a bad idea.

 

[tlbroadbent]

You can insert the result set of a stored proc into a temporary table. Then select from the table.

Create Table #temp(Tdate datetime, rCount int)

INSERT #temp
EXEC usp_someSP

SELECT tDate, Tot=Sum(rCount)
FROM #temp
GROUP BY tDate

Drop Table #temp

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.comcast.net/sql/sql_articles.htm