Roy Ernest (2/8/2011)

Only four people responded? I am surprised. I know that there are...

Okay, I have read all the posts in this thread and I have come to a conclusion:

My answer to the interviewer would simply be another question: Why? Using the...

Here is what would help, the DDL for the tables, some sample data, and expected results based on the sample data.

In you latest post I noticed that you now have...

Have you checked the examples in Books Online? They are fairly simple.

If actual datetime columns, you should either use null for the active record end date (many will argue against this) or use 9999-12-31 (which I think more would agree to)....

Are these date columns defined as character or datetime data type?

EDIT: For those interested, the links above are broken.

WayneS (2/3/2011)

Hmm, neither of these go anywhere (well, the first goes to the main forum...

May I ask why you are using RENAME instead of MOVE?

Amazing it is how arrogant some may be.

And then to post here as well?

Okay, what do you think the code is trying do?

I don't have any code, but I can give you a gentle push in the right direction. Lookup DDL triggers in Books Online. Also, event notifications. Either...

What do you get when you run this code?

Not really, can't see from here what you see from there.

You want a guess, trying to put 2000 bytes in 1500 byte record. But remember, that's just a guess,...

What size batch file are you using?