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)
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