Do you guys realize that there are more members than there are posts on this site?? There must be a massive amount of traffic comming from the search engines.

They'll be at least at 750'000 by then (assuming 12 months between summits).

Maybe even 1M if this site grows like it should... are you guys ready for the wikipedia??

I see. I think the DDL trigger can still do the job here (didn't check bol to be sure). I think it's your safest bet at this point.

Go into books online and learn how to do that. You must list all the columns you want to transfer in the insert clause and into the select clause....

This will still work... unless I missed something obvious :

BEGIN TRAN

Insert into WaitList (Columns) Select Columns FROM Candidates WHERE ID IN (2,4,5)

DELETE FROM dbo.Candidates WHERE ID IN (2,4,5)

COMMIT TRAN

Wow, that's the clearest explaination I ever saw for that question. Thanks Sergiy.

Let's start over.

Show us sample data from all three tables before the transfer.

Then show us what data needs to move and what information you have available at the moment of...

Nobody could have, thanks for pointing this out.

Testing GTM-5...

This works for me.

I don't get what is the problem in this context. The code should look a lot like this :

BEGIN TRAN

Insert into WaitList (Columns) Select Columns FROM Candidates WHERE...

Hey Steve, that would definitly make a good article. Maybe you could even make a contest out of it (like the nightmare contest). I'm sure we'd get a...

That's what I see.

Just send the CEO your resume and say you can cut off that price by at least 20%... Hired ;).

Damn, there were still Dbas left Friday night. I guess I missed them all. It was like a ghost town right after the last session has started.

Might also be a good time to ask for a laptop while you're at it :hehe:.