Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-08-24 : 09:12:15
|
sqlguy writes "Hi all,
I have an app with VB front end and SQL7.0 backend, I am using ADO to query data, and I am mostly using stored procs for the same.
I have this problem, suppose i have a form to create a user and associate him to various groups available in the system(our app) , I can essentially end up with single user and multiple groups. I have a user group mapping table where in I insert one row for each group the user belongs to.
if the sp does the insert into that table how do i call this sp from the front end..do i have to call it as many number of times as the number of groups an user is associated with? coz i cannot pass all the groups as parameter to the sp coz the numebr is not fixed...and sql does not have an array datatype.
Any pointers are really appreciated. Thanks"
|
|
|
|
|
|
Multiple Insert