I have to work with a database where a numeric code that can be one, two or three digits long and be listed in reports in proper numerical order is...

I'm hitting this same problem using Management Studio.

In my case the SQL is trying to add new records for reference numbers which don't already exist in the target table (I've...