Trigger with Stored Procedure [Client Points]

Hi list,<br /><br />I have a table like this:<br /><br />Points<br />---------------------------------<br />Id<br
/>operation<br/>value<br /><br />and another two tables like this<br /><br
/>Client                                       Rule<br /> ------------------------                      
-----------------------<br/>id                                             id<br
/>name                                      percent <br />Points<br /><br /><br /><span style="font-weight: bold;"> ps:
ThePoints table is a table that represent each moviment of the Client.</span><br /><br /><br />I need to make a trigger
thatsee after all insert on Points table and update the client table based on the percent on the Rule table. <br /><br
/>Anyonethat would like to help me I will be very welcomed.<br /><br />My best regards ...<br />Ezequias<br /><br /><br
/><br/><br /><br /><br />I must do trigger to update a table based on a field a Stored Procedure to update a table
based<br clear="all" /><br />-- <br /> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-<br
/>                                  Atenciosamente(Sincerely)<br />                        Ezequias Rodrigues da
Rocha<br/> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-<br />A pior das democracias ainda é
melhordo que a melhor das ditaduras<br />The worst of democracies is still better than the better of dictatorships <br
/><ahref="http://ezequiasrocha.blogspot.com/">http://ezequiasrocha.blogspot.com/</a>