SQL: Using the colums returned by a stored procedure

BrokenArrows · 24-10-2012 10:54AM #1

There is a stored procedure in the database im working on Sybase SQL

The SP doesnt alot of calculations on multiple tables then does a select and displays the results from a temp table that it created.

I would like to modify the results of what is returned to SUM and GROUP some columns.

Is there a way to do this without modifying the actual stored procedure.

obviously the below doesnt work but i think it gets across what im trying to do.


SELECT col1, col2, SUM(col3) FROM
    CALL sp_myStoredProc()
WHERE col1 = 1234
GROUP BY col1, col2

Beano · 24-10-2012 12:46PM

I'm not a Sybase guy but the following works in SQL Server so may work for you. you can create a temp table and insert the results from the stored proc into that temp table. you can then do your grouping on the data in the temp table. Something like :

create table #temp (id int, val varchar(100))
insert into #temp
exec sp_myStoredProc @value, @value, @value, @count OUTPUT

BrokenArrows · 24-10-2012 02:19PM

Beano wrote: »

I'm not a Sybase guy but the following works in SQL Server so may work for you. you can create a temp table and insert the results from the stored proc into that temp table. you can then do your grouping on the data in the temp table. Something like :

create table #temp (id int, val varchar(100))
insert into #temp
exec sp_myStoredProc @value, @value, @value, @count OUTPUT

Tried a few variations but no luck.

Beano · 24-10-2012 02:28PM

try here http://stackoverflow.com/questions/166080/how-can-i-get-data-from-a-stored-procedure-into-a-temp-table

BrokenArrows · 24-10-2012 02:34PM

Ah finally got it working.

I could have sworn i tried this before and it failed. Fairly simple.

SELECT * from my_stored_proc() where xyz = 'asd'

my mistake was i was using CALL when it wasnt needed.

SQL: Using the colums returned by a stored procedure

Comments