I want to send a multiple SELECT to SQL Server that creates intermediate result sets to be used in later SELECTs and I want to return only the final result set for use in my program.

I suspect there's a way to accomplish this, but have been unable to open the SQL Server books to get more information. It's installed (books) but I can't find how to open it.

Can someone provide the hints needed to accomplish this?

Thanks