Pass a recordset to a stored procedure?

[jlsmithhartfiel]

I have a page that is returning a record set based on a sql query.

Is there a way to pass this recordset to a stored procedure for manipulation?

TIA

Jessica

 

[lebisol]

"way to pass this recordset to a stored procedure "
--> did u mean to say "to use stored procedure to filter or manilpulate(edit/del/add) the records and generate recordsets?

> need more info?
:: don't click HERE ::

 

[jlsmithhartfiel]

more to do calculations on the recordset & pass back those calculations; rather than doing the calculations in asp. Like using sql to sort the passed record set which is already a filtered & sorted for display purposes, but I need to resort for calculation (specifically median).

Am storing & sorting the results in an array now & it's slow. Wondering if I can use sql to sort the recordset, calc the median & return the value.

Jessica

 

[lebisol]

not very good at cals and stored procs. but I know u can sort the recordsets in procedures (assuming u pass the sorting vars from ASP page) and return the value as well...

http://www.stardeveloper.com/articles/display.html?article=2001050101&page=1

> need more info?
:: don't click HERE ::