nice one Martin,

That's a nice and easy way to do the updates.

...And independent of identity values in the table.

Hi Arup,

I'm fairly new to SQL so maybe it's a stupid question, but why do you use a temp-table in the last example? I think there's no use for that...

I totally agree with Julie...

Many thanks Jason.

These tips can certainly save a lot of time...

Jochen

This one was quite simple (even for a n00b like myself :D)

But a good try anyways...