I'd like to have more info on the tables involved (how these 2 join to each other and how they join to the tickets table).
It would also be nice to give us a brief explanation on what each field means to you (don't assume we all understand the same by ownerId or whatever).
Also wouldn't you want to keep a datetime on the escalation history and the user assigned ?
adam_k
Veteran Poster
1,057 posts since Jun 2011
Reputation Points: 274
Solved Threads: 205
Skill Endorsements: 11