Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vinay789
Starting Member
40 Posts |
 Posted - 2009-07-15 : 01:35:11
|
| 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. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-15 : 13:42:01
|
| i think its easier to control this by a parameter. just set a month parameter and default it to current month (you'll get it from getdate()). then for each of links next and prev give jump to report option to navigate to same report but with month parameter value as current value + 1 |
 |
|
|
|
|
|
Retrivimg values month by month from ms sql