Hi ,

Thanks for the query.. Just a minor change and it worked.:-)

Thanks a lot.

My problem is solved 🙂

Ya , thanks

That will do.

Nobody around !

Hi ,

Thanks for your suggestion .

It is something new for me ... I would definately like to implement this thing .You have also given a very good explanation .....

Here is the proper sample data

CREATE Table VL

(Code varchar(20) ,not null PRIMARY KEY clustered

vlcode varchar(20) not null PRIMARY KEY clustered)

--===== Insert the test data into the...

Hi ,

Have i missed anything here while posting , please let me know if that is the case...

Regards

aditya

Sorry for the late reply and some absurd data.

I was posting these posts while at work and gave you the wrong data . Anyways , just consider the dates as...

HI ,

While updating this data , the update is going in endless loop .

It doesnt found the rownt-1 row when rowcnt is 1

1-1 = 0

Is it the issue with permissions ?.

As per MSDN library , i created the config file . Edited the file with configured value . Do i need to change the...

Thanks a lot ...

It worked .

🙂

Order by col1,col2,col3

NO group by

Pls refer the attched sample sheet .

NO , the row before that should have enddate you specified.

Sorry ,

I need to update enddate using startdate .

Previousday of startdate should be enddate.

Thanks