Thank you govinn.  It works perfectly.

Thank you Phil, that's it, the problem is resolved. 

The primary key is not an identity field.  And if I add this primary key into my import, I got the same error:

Violation of Primary...

Thanks. It's really helpful.

I have tried different ways to convert it to null, but when SQL Server sees null value in the smalldatetime field, it seems put a default value 1/1/1900 automatically.

The way...

Thank you for all of your replies.  I think what happens is when it's empty string, the retrieved session value from txtDOB.text will turn to #12:00:00AM# before it inserts to...

yes, in my asp.net application, i have put the code to check if the textbox contains null value:

If txtDOB.Text = Nothing Then

Session("DOB") = DBNull.Value Else

Each employee can have up to 5 records (5 PayCodes)I need to ensure each employee : their payamt of PayCode 2 =1.5 * PayAmt of PayCode 1.

Example Table:

For example:

EmpID  PayCode ...

Yes, the Update_Ind is only at the 1st table (UPR00100).  If there's any updates in 2nd table (UPR00200), the trigger should set Update_Ind=1, and nothing to do with 2nd table...

Thanks for your help.  But I still have problem with my 2nd trigger.

The 2nd trigger will update the 1st table (set Update_Ind=1) when there's a update on 2nd table (UPR00200). ...

Never mind, I got it work:

ISNULL(CAST(CONVERT(CHAR(8), F.Transmit_Date, 10) AS VARCHAR(30)), 'Not Transmit Yet') AS TransDate

Thank you.

Farrell, thank you it works. But I still have a question:

Transmit_Date is a smalldatetime, which should display 1/14/2005 12:00AM.  After I casted to varchar, it displays Jan 14, 2005 12:00AM,...

Thanks, this is exactly what I need.

Thank you very much, it works.

Yes, please ignore this one because I found out I should use OpenRowset and I don't know how to delete this post.