asp.net + sql same entries for multiple user

[dreamguyster]

Hi,

I have created task management systems.

Now the problem is Admin will create the task and once he created the task he may select single or multiple user to assign the task.Users Id will be a forie\egn key of task_details table.

How can I store the same task for multiple user wit same task ID.Should I loop through in store procedure ??
I want to know Only Users multiple but task is single how can I write store procedure ?? How can i check in storeprocedure that userid param have multiple values ?

Can anybody help ???

[Mudassir]

well you will have to create separate tables to manage this kind of relationship, like
Table1 will have following information
TakId,TakName
Table2 will have
UserId,UserName
and Table3 will have
TaskId,UserId (both will be foreign keys here)
and you dont need to execute loop in your stored procedure rather you will have to loop through from your front end i.e write the loop in your code to execute the stored procedure..
Regards
Mudassir