STORED PROCEDURE OR TRIGGER ?

• bamek_daddy

  SSC Enthusiast

  Points: 133

  More actions

  March 13, 2011 at 7:25 pm

  #157484

  HELLO!

  I have two tables : product , tax

  Product'fields:

  id amount Tax

  1 ; 150 ; ?

  2 ; 300 ; ?

  TAX fields : Range_start ; Range_end ; TAX_Amount

  start end Tax_Amount

  100 ; 200 ; 10

  201 ; 300 ; 25

  301 ; 400 ; 30

  For amount of 150 tax is 10

  for amount of 201 tax is 25

  help to write a trigger or stored procedure to select and insert tax_amount in product table when amount is inserted .

  Thanks.

• ColdCoffee

  SSC-Dedicated

  Points: 39972

  More actions

  March 13, 2011 at 7:37 pm

  #1298170

  Cross post - Please redirect ur replies to http://www.sqlservercentral.com/Forums/Topic1077515-149-1.aspx