var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Trigger help!
Hey all ,
Just wondering if the possible trigger is possible - and if so how would it be written???
I need to write an insert trigger on a table (lets says tbl1) that will insert data into another table- tbl2.
The data that will be inserted into tbl2 will include data from tbl1 (lets say colA of the newely inserted row) as well as from another table - tbl3.
The data that will need to be extracted from tbl3 and thus inserted into tbl2 includes all those rows which match colA of tbl1. So there could be more than one row that needs to be inserted into tbl2.
Hope this is making some sence so far ...
How would one go about writing such a trigger - if it is possible???
Any hints, tips, advice will be very much appreciated!
Many thanks in advance,
No worries - sorted!
You can do the above and its quite simple just use cursors! - duh duh duh on my part!