I don't think this is possible.
Even though SQL Server itself caches query plans, stored procedures etc., there is no way to access this cache from a program AFAIK.
You can always use a temporary table if you want to store results temporarily, do some processing on them and then drop the table.
Quick Overview: Temporary Tables in SQL Server 2005[
^] might help you get started with temporary tables.