SQL Server stored procedures to page large tables or queries

Example #3 - Using a global temporary table to hold the whole result In this example, I use a global temporary table to store the complete result set of the query. In this scenario, this temporary table will be populated during the first execution of the

www.mssqltips.com