Very usefull staff !

paging example :

with searchCTE as

(

selectCode,

Descript,

ROW_NUMBER() over ( order by Code ) as RowNoCode,

ROW_NUMBER() over ( order by CAST(Code as BIGINT)) as RowNoCodeNum,

ROW_NUMBER()...