thbaig (8/10/2015)
Yes, I have confirmed. Overall data set size in temp table is ~100k rows.When I set offset it terminate on EndRows , but always start from 0. e.g. if I set page size 10 and pageNumer 2. It return 20 rows instead 10.If I set EndRow 40, it return 40 records
Just an FYI, if you ever fail to supply a value for PageSize to the proc, you will indeed start at 0, as the variable will be set to 0 as a result.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)