the best way is to switch to your own cursor, and do whatever you were going to do to the specific tables;

here's a generic example; note how you could exclude just specific tables, or do it the better way and select only the tables you REALLY need:

declare

@isql varchar(2000),

@tbname varchar(64)

declare c1 cursor for

--EXAMPLE1

--every table except specific ones

--select name from sys.tables where name not in ('accounting','orders','invoices','payroll')

--EXAMPLE 2

-- only the suite of tables startingwith exp

--select name from sys.tables like 'EXP%'

--EXAMPLE3

--only tables with the column name i was looking for

select object_name(object_id) from sys.columns where name ='COMPLETEDDT'

open c1

fetch next from c1 into @tbname

While @@fetch_status <> -1

begin

select @isql = 'UPDATE @tbname SET COMPLETEDDT = GETDATE() where COMPLETEDDT IS NULL'

select @isql = replace(@isql,'@tbname',@tbname)

print @isql

exec(@isql)

fetch next from c1 into @tbname

end

close c1

deallocate c1