How to re-insert all old rows when month and year changed

Question

my table like........

 id  Sname  attendence    ADate  
  1   xyz        p          01/01/2013  mm/dd/yyyy
  2   zxc        A          01/01/2013
  3   asd        p          01/01/2013

Now if month changes then these rows auto-insert on page load event like

 id  Sname  attendence      ADate  
  1   xyz        p          01/01/2013   mm/dd/yyyy
  2   zxc        A          01/01/2013
  3   asd        p          01/01/2013
  1   xyz        p          02/01/2013
  2   zxc        A          02/01/2013   mm/dd/yyyy
  3   asd        p          02/01/2013

Previously I used only month 1, 2, 3,4 for this but problem with this is while it comes to 12 I have to insert 1 so it will affect old row. Please tell me what to do

Welcome to StackOverflow: if you post code, XML or data samples, **please** highlight those lines in the text editor and click on the "code samples" button ( `{ }` ) on the editor toolbar to nicely format and syntax highlight it! — marc_s, Jan 03 '13 at 06:02

score 0 · Answer 1 · answered Jan 03 '13 at 06:06

0

Use cron jobs

For this you can create a page which runs automatically on first date of month.

answered Jan 03 '13 at 06:06

Rohan Kumar

40,431
11
76
106

i am using it in windows applcation – user1768465 Jan 03 '13 at 06:31
It may help you http://stackoverflow.com/questions/2348863/how-to-run-a-stored-procedure-in-sql-server-every-hour – Rohan Kumar Jan 03 '13 at 07:07
Another example `Hourly cronjob on Windows` http://stackoverflow.com/questions/1192580/hourly-cronjob-on-windows – Rohan Kumar Jan 03 '13 at 07:11

How to re-insert all old rows when month and year changed

1 Answers1