Home Forums SQL Server 2008 SQL Server 2008 - General Update a date field with a Trigger when a transaction is posted to another table RE: Update a date field with a Trigger when a transaction is posted to another table

  • May 11, 2014 at 4:10 am

    #1712457

    Your problem is CUSTOMERS UniqueID is char(17) and TRANSHEADERS UniqueID is int

    SQL Server is trying to implicitly convert CUSTOMERS UniqueID to int to match against TRANSHEADERS UniqueID but at least one row in CUSTOMERS has a blank UniqueID

    Far away is close at hand in the images of elsewhere.
    Anon.