Filter stored procedures recordset results
Posted on 2006-05-03
Hello...running IIS, ASP/VBScript, iSeries backend...I have a stored procedure that returns a small recordset (<100 records). If I edit the SP to accept a parameter from a drop down list to filter the results down further, it works but it is very slow (page load is >1 minute). If I take the parameter out, load time is much faster but I need to be able to filter the results. My question is, is there a way to filter the results without a parameter being passed...something I can do client side? Thanks!