Paging

DECLARE @intPage int;
DECLARE @intPageSize int;

SET @intPage = 1;
SET @intPageSize = 20;

DECLARE @intStartRow int;
DECLARE @intEndRow int;

SET @intStartRow = (@intPage -1) * @intPageSize + 1;
SET @intEndRow = @intPage * @intPageSize;    

WITH items AS
    (SELECT *, 
     ROW_NUMBER() OVER(ORDER BY MsgBrdName DESC) as intRow, 
     COUNT(MsgBrdName) OVER() AS intTotalHits 
     FROM tbl_MsgBrd_MsgBrd)
SELECT * FROM items
WHERE intRow BETWEEN @intStartRow AND @intEndRow