Results 1 to 2 of 2

Thread: Trigger help!

  1. #1
    Join Date
    May 2005

    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,


  2. #2
    Join Date
    May 2005
    No worries - sorted!

    You can do the above and its quite simple just use cursors! - duh duh duh on my part!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts