Hi @Mr. Brain Gale,

Thanks a lot for your response.

Sorry for the confusion.

I have updated data.

Based on Table3 col9 need to recursive to Table1 col1

• This reply was modified 4 years, 9 months ago by  s.ravisankar.

Hi All
Thanks for your reply

I have checked with direct query then its not increasing log

If I am having dynamic query then its increasing log

Thanks Joe,🙂

I got it and modified based on order by offset,

Can you help me for how to do for multiple tables?

DECLARE...

Sorry for the late response

I need SQL Query for this

@batch_count is configurable (common for all tables)
@incremental_value =1

I have table1 with 500000 records  need...

Hi Luis C,

Can you explain me ?

Thanks a lot Luis C and Everyone.

I am sorry, This is first time I am coming for Forum, Give suggestions if I want to improve the things both Personally and Technically.

CREATE TABLE #Temp1

...

c1<---->c2

1<---->2

2<---->3

3<---->4

11<---->12

12<---->13

13<---->14

We have data like this

I)

In transaction 1 : 1 updated to 2

In transaction 2 : 2 updated to 3

In transaction 3 : 3 updated to 4

II)

In...

1 is updated to 2

then 2 is updated to 3

then 3 is updated to 4

here I want to update 4 for all (1,2,3) because 4 is the final...