In my stored procedure , I have a select statement which retrieves some table names based on where condition.
I have to update a particular column in all these tables using update query.
my select query is

select from sysobjects so,syscolumns sc where =
and = 'productNum' and so.type = 'U'order by

how can we give these dynamic tables in an update statement

kind of urgent.. please help