Retriving values month by month from ms sql

• bvinay57

  SSC Veteran

  Points: 224

  More actions

  July 15, 2009 at 3:42 am

  #212440

  Hi

  I am new bie to mssql server 2000.I am developing a report project using pagination and in my database there are lot of date records i want to select first time current month records dates only and when user clicks next or previous button in pagination i want to select previous month or next month records dates only.I am sending query which i want to modify please help me to solve this problem.

  "select COUNT(date),date,country from advertisementhits where transactionid='9P853908BJ2391528521"' GROUP BY date,country"

  Thanks in advance.

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  July 15, 2009 at 6:09 am

  #1024946

  Same as here:

  http://www.sqlservercentral.com/Forums/FindPost753166.aspx

  -- Gianluca Sartori