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>
