CREATE TABLE #inList (inValue char(30) )

insert into #inList values ('500')

insert into #inList values ('610')

select *

from <yourTable>

join #inList on <yourTable>.<yourColumn> = inValue

drop table #inLIst

GO

You are correct... Didn't notice mention of how large the tables are?

You can rewrite the inner loop to make a single update by continuing to append the set values for...

Don't necessarily recommend it.. but here is how its done...

Replace your_table_name_here with table name. check the output... change type list if necessary...

When you are ready to run, uncomment the exec...