asimnazir123
July 9th, 2003, 08:24 AM
hello,
here is a problem i am facing.
i have a from DATE column in my table and i have a to DATE column.
i have values in from DATE column, but nothing in to DATE column.
now i want to put the values in such a into to DATE column that second value i.e value in second cell is assigned to first cell in to DATE columns and then 3rd to second of to DATE column and so on.
and at the final cell the current date.
i can show it like this.
from to
2003-07-08 17:01:00.000 2003-08-08 17:01:00.000
2003-08-08 17:01:00.000 2003-09-08 17:01:00.000
2003-09-08 17:01:00.000 2003-10-08 17:01:00.000
2003-10-08 17:01:00.000 current date i.e. todays
i am using sql server2000
ASIM
here is a problem i am facing.
i have a from DATE column in my table and i have a to DATE column.
i have values in from DATE column, but nothing in to DATE column.
now i want to put the values in such a into to DATE column that second value i.e value in second cell is assigned to first cell in to DATE columns and then 3rd to second of to DATE column and so on.
and at the final cell the current date.
i can show it like this.
from to
2003-07-08 17:01:00.000 2003-08-08 17:01:00.000
2003-08-08 17:01:00.000 2003-09-08 17:01:00.000
2003-09-08 17:01:00.000 2003-10-08 17:01:00.000
2003-10-08 17:01:00.000 current date i.e. todays
i am using sql server2000
ASIM