SQL Server Update with Join / Active Column -

i think code better show, want do:

update set a.[changed] = 1 [dbo].[table1] inner join [table2] e         on [a].[part] = [e].[activepart]  update [dbo].[table1]     [range] = [range] [partgroup] = [partgroup] , [changed] > 0 

before update:

after update:

please help.

thank much.

greetz vegeta_77

yes, first part looks better (even if think isn't needed, since concerns same column joining on). nevertheless, second update shouldn't produce changes:

update [dbo].[superliste_000] set [plan-tgrp-spanne_stfl1] = [plan-tgrp-spanne_stfl1],     [plan-tgrp-spanne_stfl2] = [plan-tgrp-spanne_stfl2],     [plan-tgrp-spanne_stfl3] = [plan-tgrp-spanne_stfl3],     [plan-tgrp-spanne_stfl4] = [plan-tgrp-spanne_stfl4] [teilegruppe] = [teilegruppe] , [date_change] > 0 

again update [plan-tgrp-spanne_stfl1] [plan-tgrp-spanne_stfl1] - same value... either tired , misinterprete code or there little bug in update. ;-)