I'm trying to create a procedure that can acccept at least three but up to 20 parameters...does anyone know how I can do that?
Basically what I want to do is to write a procedure that helps the users to insert records to 2 tables:
Project (PID, Name...)
Project_Employee (PID, Emp_ID)
So I'm trying to write a procedure, something like:
insertProject (PID, Name, Emp_ID1, Emp_ID2,....)
How do I declare a procedure that accepts 3 to 20 parameters? An example would be extremely helpful.
Thanks much for your help.