Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: trigger
Hi,
I have never written triggers before, so would apprecite any helpor suggestion on this.
 
In my database I have 2 tables:
 
Master table (Orders)
OrderId
Department
Status
 
Table: Priority
OrderId
OrderPriority
 
What I want is:
 
1) Insert new priority:
when a status of an order is changed to "In Progress" in the master table, a new record should be added to the priority with a defualt low priority based on the department. Ex.if Priority table has 5 orders for department 001,then the order should be added with priority 6
 
2)Remove Priority:
when a status of an order is changed from "In Progress" to something else in the master table, then delete its priority in the Priority table and readjust the priorities for the related department. Ex.if Priority table has 5 orders for department 001,and the order for which the status got changed has priority of 3, then, delete this record and readjust the priority for the subsequent orders in that department.
 
Currently I am doing this through code, but hope that this can be managed within the database without putting extra coding load as I have many department and orders that needs to be maintained in such a way.
 
Thanks,
Navin
Posted 17-Dec-12 10:48am

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 478
1 Sergey Alexandrovich Kryukov 305
2 PhilLenoir 115
3 RajeeshMenoth 110
4 Uma Shankar Patel 80
0 Sergey Alexandrovich Kryukov 6,557
1 OriginalGriff 5,966
2 CPallini 2,473
3 Richard MacCutchan 1,687
4 Abhinav S 1,540


Advertise | Privacy | Mobile
Web01 | 2.8.140821.2 | Last Updated 17 Dec 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100