• Post Reply Bookmark Topic Watch Topic
  • New Topic

Pls Help..Triggers

Aman Gupta
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

I did not create any SQL trigger or procedure before. What I need is that I have 6 tables as:
1- Parent1 [Employee]: EmpID (PK), EmpName ...etc.
2- Child1 [EmpCourse]: EmpID (FK), CourseName, ...etc
3- Child2 [EmpExperience]: EmpID (FK), ExperienceSource, ...etc.

4- CopyofParent1 [Employee]: EmpID (PK), EmpName ...etc.
5- CopyofChild1 [EmpCourse]: EmpID (FK), CourseName, ...etc
6- CopyofChild2 [EmpExperience]: EmpID (FK), ExperienceSource, ...etc.

CopyofParent1 columns is superset of Parent1 columns.
Similarly for CopyofChild1 and CopyofChild2.

As soon as a record in Parent1 is inserted and meets a certain criterion, the record shd be inserted in CopyofParent1 using EmpID .
At this time, records from Child1 and Child2 for the same Parent shd be inserted in CopyofChild1 and CopyofChild2 resp.

Please help.

Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!