Thanks guys, I've gone with the temp tables as it was quicker for me to implement rather than test the other code. I will have a look at it when...

Hi Steve,

I now get the following error.

Server: Msg 214, Level 16, State 2, Procedure sp_executesql, Line 51

Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'.

Any ideas why this is?

A colleague...