You are absolutely right, David.

Only one note: using of SmallDateTime for DateOfBirth is little risky.

There are more than 25000 people in Japan older than 100 years. Thier DOB could not...

And what is the record about previous backup of this DB?

Was it successful?

Problem with CHAR is not ony disk space.

You cannot add anything to the right of CHAR value, you must RTRIM it first.

Try to do this:

declare @T TABLE ( A char (5),  B varchar(5) &nbsp

Did author ever think about purpose of the IDENTITY column in his temporary table? It's perfect tool to replace loops!

He needed just to add another column to his temporary table:...

Converting of varchar to datetime really depends on your local settings. If SQL server can convert 6/23/2004 it cannot recognize 23/6/2004. There are many other tricky faults with dates conversion. And...

They tried to ask a question about bcp and constraints but this insert will fail because of 2 other reasons.

And of course you cannot guess that they don't care about...