Hi All

I too have a query, please if possible can you help me?

I have a table called Replication_Tables which has columns 'LatestTransID', 'SchemaName' and 'TargetTable'. The schema name is 'CLAIM' for all rows and the table name is different for each row (depending on which table it is referring to). What I am trying to do is create a stored procedure which uses a 'FOR' statement which updates the 'LatestTransID' column in the REPLICATION_TABLES table by selecting the max(TRANSID) from each Table listed in 'TARGETTABLE' column. I have never used 'for' statements, please help?

Regards
Tracy