Update column value from another table sql server

Top sites by search query "update column value from another table sql server"

sql server - Trigger to update a date field on one table when another table is updated - Database Administrators Stack Exchange

  http://dba.stackexchange.com/questions/64734/trigger-to-update-a-date-field-on-one-table-when-another-table-is-updated
I changed your provided example, ran the script and it was successful, however, what it did was to update the ZLastSale date on all Customers with todays date. It runs and up dates the custom field, however when a new transaction is entered into the database the custom field is not updated which is what I want

  http://scottonwriting.net/sowblog/archive/2010/07/13/howto-update-records-in-a-database-table-with-data-from-another-table-ms-sql-server.aspx
To ease data entry, let's say that administrative users can create "ticket templates," which pre-define the values for a number of ticket data points that are stored in a table named TicketTemplates. Applying a template to an existing ticket would require that the existing record in the Tickets table have its non-set data points assigned to the corresponding default values of the selected template