Loops in Sql Server Triggers and Stored Procedures

Reply

Join Date: Mar 2006
Posts: 36
Reputation: web developer is an unknown quantity at this point 
Solved Threads: 0
web developer's Avatar
web developer web developer is offline Offline
Light Poster

Loops in Sql Server Triggers and Stored Procedures

 
0
  #1
Apr 18th, 2006
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
Life Is A Big Code
Rushdy Ibrahim
Egypt
Reply With Quote Quick reply to this message  
Join Date: Feb 2005
Posts: 1,181
Reputation: hollystyles will become famous soon enough hollystyles will become famous soon enough 
Solved Threads: 67
hollystyles's Avatar
hollystyles hollystyles is offline Offline
Veteran Poster

Re: Loops in Sql Server Triggers and Stored Procedures

 
0
  #2
Apr 18th, 2006
==========================================
Yadda yadda yadda...
Web junky, fevered monkey
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:




Views: 15613 | Replies: 1
Thread Tools Search this Thread



Tag cloud for ASP.NET
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC