Re: [SQL] Trigger with Stored Procedure [Client Points]

[Aaron Bono]

On 8/30/06, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote:

Hi list,

I have a table like this:

Points
---------------------------------
Id
operation
value

and another two tables like this

Client                                        Rule
------------------------                       -----------------------
id                                             id
name                                       percent
Points


ps: The Points table is a table that represent each moviment of the Client.


I need to make a trigger that see after all insert on Points table and update the client table based on the percent on the Rule table.

Anyone that would like to help me I will be very welcomed.

 

I am not exactly sure what you are trying to do here.  Can you provide an example of the data and what you want to occur?

==================================================================
   Aaron Bono
   Aranya Software Technologies, Inc.
   http://www.aranya.com
   http://codeelixir.com
==================================================================