Probably you can assign this resultset to a table variable or a temp table and can make use of the same later when required.