I would suggest, for a quick start, try Lynda.com and their training series. It will get you through some of the basics and help you to setup a server...

Lowell,

Adding rtrim before the column name worked perfectly. The column is actually nchar. Can you tell me what this data type adds to the end of data which...

WayneS,

This is in fact a one-to-one relationship. Do you believe a stored procedure would be a better choice then a trigger in this situation?

Stamic,

The code you suggest has worked even with a unique constraint. What is and where did you find the "FROM INSERTED"?

Dan,

Great movie and quote. The code did cause a violation of the unique constraint that is on table 2 tuple CustomerID. What we are attempting to do is...