If query

[eluser]bgreene[/eluser]
stored proc is in the database, same way as a table is. create it using heidimysql (freeware) or similar.
then all u need in ci is a single qry like "select * from myprocedurename(filtervalue or whatever)"
but u need to read up on stored procs