dr_lubin

I completely agree. And I guess I did come off that way... my bad.
I don't want anyone to do it for me.

Moving on...

create tables; done.
Trigger, done.

This cursor question, #2 - is where I am having problems.
I think I'm set passing the divName in, and retrieving the employeeID from that division table... Next I'd have to (in speaking terms) take that value and compare it with the Employee table, and store all the matches. Of those matches, I need to run any employee ID's that don't match the initial one, against the entire employee table, and get out those matches - because they would be those employee's indirectly managed by the first division manager passed in. And again for other ID's different in that first result.
I am not finding good cursor examples in my book, class notes, or the web, that can show me how a cursor works, as well as syntax for accomplishing this.


*** edit:

Project done, no problems. Thank god for Google.

I appreciate the moral support.

__________________
I'd rather regret what I did do than what I didn't.