Thanks!, good stuff! I will practice your technic!

Cheers!

Bill, I like your version!

Thanks.

You must first define the way you will capture the changes in the LIVE_DB.

What is the retention policy of this,

you can partition your data by datetime and have a full...

I like the xml way, then I worked on that version

Here is another way thanks to this forum. It is a generalize version.

I prepared this version (my original did not...

I think you must define what is the goal of the question.

as a plain English the question is clear, and you are asking for a specific result: an instance (defined...

in the question never showed an implicit date time conversion, therefore you can not require that condition as granted.

Your question is bad formulated or you are trying to trick (fool)...

in the question never showed an implicit date time conversion, therefore you can not require that condition as granted.

Your question is bad formulated or you are trying to trick (fool)...

something is wrong in the page for that question.

My choice was "Binary" and I got wrong answer like if my choice was "Balanced"

The question is too generic about the character entered.

My choice was nvarchar(1) to cover all posibilities and I think it is the right answer.

The question was what to do , so that we can update the schedule;

Not what is the best choice.

So the answer " Run the job manually, then...