Hey
Does any one knows how this T-SQL works ?
WITH ONE_MIL_t AS
(SELECT * , ROW_NUMBER() OVER (order by abc, startdate)as RowNumber
FROM ONE_MIL )
SELECT *
FROM ONE_MIL_t
where RowNumber between 20 and 100000 ;
Does SQL Server creates temp table or a virual table in the memory dynamically.
Can i get resulset like rows + row_number between 100 - 200 using cursors. Will cursor give same performance like above or ???
Regards
Shrikant Kulkarni