Here is a SQL statement that I am currently running:

update timecard set tudef1='JP0' where tudef5='JP' and tmatter in
(select mmatter from matter where mloc='30')

I would like this update to happen when a new record is inserted in
the timecard table. How can I set up a trigger to do this.

Thanks in advance

Rich

Richard (richard.mogy (AT) gmail (DOT) com) writes:
See response in microsoft.public.sqlserver.clients.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx