Hi, thanks for the reply.

I've started to look at this solution and it nearly fulfills my need. The one problem that I have is that because my new column...

Thank you, that seems to have done it.

Great Thanks, that worked a treat. On a similar deal, what if I didn't want to have an identity field, but instead I wanted to hard code a value.

So 3...

Thanks yes, I found some code on MSDN that was taking me down creating a Repository Object and using that, but I was having problems with the connection. I have...

Guy's the reason I'm using temp tables in this way and deleting them at the start of the script is that the script runs during an overnight process and then...

Hi Andy,

Yes, I've resorted to using that. It's just that I have a number of tables and I thought it would be easier to just turn error handling off at...

Sorry,  I didn't see the subtle change from 'Values' to Select. I have changed to Select and now works. THanks Very much.

Incidently, if I did want to do this as...

Hi MKEast,

I tried the above but I receive error:

Msg 1046, Level 15, State 1, Procedure InsertImage, Line 34

Subqueries are not allowed in this context. Only scalar expressions are allowed.

So...