Hi RBarry Young

sorry to bug you again, but i came across another issue when running this on another server

seems there's a 256 limit somewhere

Msg 106, Level 15, State 1, Server NSAB-SS83-SQL-N, Line 1218

Too many table names in the query. The maximum allowable is 256.

Msg 102, Level 15, State 1, Server NSAB-SS83-SQL-N, Line 1234

Incorrect syntax near ')'.

Msg 102, Level 15, State 1, Server NSAB-SS83-SQL-N, Line 1256

Incorrect syntax near ')'.

Thanks

Jiim