Hi Sir,

There is no any PK , I just want to update the end date on the basis of id,subid and ind column, and as per above solution, its worked.

Thank...

Thanks sir for your help but is not working properly to get output what I would expect.

No sir it is not working properly to get the proper output

Sorry, I did not read your comments before posting my comments.

Yes, It is working fine.

Thanks Sir

Hi Sir,

Thanks for your reply and my requirement is as below,

The first end date of the record is null , so we need to set the seconds row start dates...

No Sir, It is not working as I am looking for end date to set prior to start date.

Hi Sir,

Just I would like to know that ,

I have to update the keys from main table but I joined more then two tables as a source.

So how to use...

Hi Sir,

Yes, this will not give an error as this is a sample sql but I do have another sql and need to use MERGE statement in it.

Thanks, but How i can do this for INT datatypes?

Please suggest me.

Thanks for your help, it works for me 🙂

Thanks Sir for the update on this 🙂

Hi Sir,

I found one of the solution when i did r&d,

SELECT Operation,[Transaction ID], [Begin Time], [Transaction Name], [Transaction SID]

FROM fn_dblog(NULL, NULL)

WHERE [Transaction ID] = '0000:535604c2' --(Use your Transaction ID)

AND...

Thanks Sir 🙂

Thanks Sir its worked for me thanks for your help 🙂

The name ABC,BBC,XYZ are active between dates 20081230 and 20110629

so records should display

102008123020110629ABC, BBC, XYZ

and names BBC,XYZ are active between dates 20110630 and 20130415 and

name=ABC is terminated on...