If it comes to worst... create a perm temp table with the spid as clustered index.  or maybe a table variable (not that I think you're allowed to do that at...

Anyone got a plan D that doesn't involve re-uninstall?

Thanx for recalling us that nothing is more important than the data... even when you are certain that nothing can go wrong!

That's a good point.  IIRC correctly this is a case where the prod server was accidentally pointed onto a test server.  And only a few rows need to be ported...

Why would that be, the 2 tests I did with it were fine on 2005 (grant it 9 and 10 are not the hardest convert tests

This becomes the user responsibility.  You can implement a set of rules where the user has to lock is PC when he leaves.  Have the pc go to sleep after...

Why wouldn't it work??

Did you have problems posting?

Sorry but that works fine for me.

What do those servers have in common? (SP, verision)??

, that was plan C .

You'll have to edit it in query analyser.  The query builder doesn't support the use of the case statement (even when legal).

Why can't the programmers do that client side???  It's a very simple loop to code and present.

Anyways if you have to do it server side create a temp table with...

Do you have a table where the employees have more than one salary???

Where do I send my resume .

I would seriously consider query...

I'm not either... I had to stumble my way around this one .

I had to go in control panel, add or remore program, look...

In my case I had to use a few uninstalls because I didn't realise that you had to manually choose all the services to uninstall (like database engine, reporting service...).

So...

If you insist .

I'll let Jeff explain this new nickname .