We need to manipulate a set of records returned from a select query. This can be done in :
- Either by saving the whole record to a table variable and then do the required process.
We can do like this
Select * from (select * from table where conditions) AS results where results.RowNum between ....
So what is the best method in this case.. using a table variable or the 2nd method. Is there any performance issues in using the second method compared to first?