0

Hi all
I am here again ,and this time i returned back and with my hand a problem in SQL server not in asp.net .
The problem is the following :

  • I am in a project that contains a table of users(user_tbl) and another table of groups(Group_tbl) . and each group can contains multi-user by

Group_Id which is foreign key in user_tbl .

  • I am now about creating a trigger that happens when inserting in permissions_tbl (contains users and group permissions) . It should insert all users of the inserted group into the permissions_tbl also with the same values the group taked.
  • So , I need Loops very much to loop in the user_tbl and get the users of the inserted group then insert them in the permissions_tbl .

I wish if some one can help me .
Thank you very much

2
Contributors
1
Reply
2
Views
11 Years
Discussion Span
Last Post by hollystyles
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.