Trigger to increment the salary by 10%

• zim-496632

  SSC Enthusiast

  Points: 186

  More actions

  September 25, 2007 at 5:57 pm

  #374815

  i want to write a database trigger to increment the salary by 10% for technicians who have done three tests on a particular date.

  there are two employee types.(1)technicians (2)traffic controllers.

  employee category is defined in "Type" attribute of Employee table. the increment should happen only to technicians.thank you in advance.

  Employee (EmployeeID,Name,Salary,Tpye)

  TestEvent(TestNo,EmployeeID,TestDate)

  Hussain

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  September 25, 2007 at 7:31 pm

  #736196

  Please do not cross-post, we monitor all threads.

  Topic answered here :

  http://www.sqlservercentral.com/Forums/Topic402783-149-1.aspx