I have a stored procedure in which I need to pass a variable number of
parameters to the sp. How can this be achieved? For example, I query
for a one to many relationship and however many entities there are, I
need to pass them to the stored procedure. If I have 3 StudyID's to 1
PatientID, for example I need to pass the 3 StudyID's. Next time there
might be only 1 StudyID passed to the stored procedure....any
Prucka Engineering, Inc.