I think u can use a temporary table to hold the result and you can fetch the result back to some variable.