Thanks, that works just fine.

Obviously for the @Script to access the temporary tables, they have to have a fixed name. However, as I understand it, temporary tables have scope...

Thanks for the prompt response, John. I'll give it a go. I'm very conscious of the performance issues, but thankfully in our situation the tables are updated infrequently,...

Reopening an old one here, but I have a similar problem and am wondering whether there is a solution.

I have a trigger which dynamically generates a script which refers to...