I have set this in my bookmark to read it later.. Thanks for sharing this.

There is Zigzag data relationship  and the last Manager ID has to be updated for all record which has this relationship

You are correct. I was completely misreading it. But how can I know what is a error this subscription throwing

Thanks for your guidance

Thanks Thom for shortest answer..
Though I was trying my hand on this
Declare @T varchar(20)
Declare @SD varchar(20)
Declare @STR varchar(100)

Declare @TowerSDGoup as...

Thank you very much Lowell.

Do we need to mention every column which is being updated in IF UPDATE statement ?

Is there any way out if any column is updated then...