When is it necessary to use a table variable, a temp table and a derived table in a stored procedure? Does it depend on the total number of records. Lets say the Stored Procedure1 returned 10,000;
Stored Procedure2 returned 100,000 and stored procedure3 returned 1,000,000,000 rows.
When creating the stored procedures above when should on implement TABLE variable, TEMP tables with an index and DERIVED table.
Stored Procedure2 returned 100,000 and stored procedure3 returned 1,000,000,000 rows.
When creating the stored procedures above when should on implement TABLE variable, TEMP tables with an index and DERIVED table.