Wednesday, 22 January 2014

Paging in sqlserver

DECLARE @RowsPerPage INT = 10, @PageNumber INT = 15

SELECT RowNum,AutoID,ADMNNO,STDFIRSTNAME,F_MOBILE,ADMNDATE

FROM (

SELECT AutoID,ADMNNO,STDFIRSTNAME,F_MOBILE,ADMNDATE,

ROW_NUMBER() OVER (ORDER BY AutoID) AS RowNum

FROM XStudentMasterCopy where ADMNDATE

between convert(varchar(15),'06/14/2013',103) and convert(varchar(15),'06/15/2013',103) ) AS SOD

WHERE SOD.RowNum BETWEEN ((@PageNumber-1)*@RowsPerPage)+1

AND @RowsPerPage*(@PageNumber)

No comments:

Post a Comment