Thanks all,

In the end I redesigned the stored procedure to use sp_executesql so that I could return values from the dynamic SQL statements. It works pretty well.

Whilst your other suggestions...

Thanks Michael, I'll try your suggestion.

I think this is probably not a job for dynamic SQL as the do something I alluded to is quite complex. Although it's not...