Tuesday, 27 August 2013

Get rows with consecutive Date(Day)

Get rows with consecutive Date(Day)

I'm searching a way to update all rows which have an other occurence the
day before.
Example:
ID Config Number Date Status
1 238 10/9/2013 1
2 351 1/9/2013 2
3 351 2/9/2013 0
4 238 11/9/2013 0
5 124 18/9/2013 3
6 238 20/9/2013 0
And after the update i would like to have something like:
ID Config Number Date Status
1 238 10/9/2013 1
2 351 1/9/2013 2
3 351 2/9/2013 2
4 238 11/9/2013 1
5 124 18/9/2013 3
6 238 20/9/2013 0
6 238 20/9/2013 0
Thanks in advance

No comments:

Post a Comment