Retrieve total rows over paging

• Daniele Franceschini

  Grasshopper

  Points: 17

  More actions

  February 10, 2010 at 5:25 am

  #156661

  Hi everybody,

  When I use ROW_NUMBER for making paging I would like to have also the total of rows that I would have without use of ROW_NUMBER.

  Currently I run a query a second time without ROW_NUMBER with the same filter of the previous query to retrieve this value. There is a better way to obtain the same result?

  Thanks.

• Nabha

  SSCrazy Eights

  Points: 8534

  More actions

  February 10, 2010 at 7:43 am

  #1116826

  I am sure this is not what you are looking for,

  Select * , Row_number() OVER (order by C),

  (Select count(*) FRom T)

  from T

  post the query in this format and you would get lot better replies,

  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  ---------------------------------------------------------------------------------