Many thanks for the suggestion but still no luck - the same error.

Having said that I got round the problem by renaming the columns in the temporary table so...

Unfortunately not - although your suggestion looks fine the error is the same:

Server: Msg 8180, Level 16, State 1, Line 1

Statement(s) could not be prepared.

Server: Msg 209, Level 16, State...