Very Computer

1. Using a trigger to select then insert multiple records

Hi

I'm trying to write a trigger in SQL Server 2000 that will fire after
I insert a new set of priviliges to a table of priviliges and insert a
record in a table of groups for each user that can have this
privilage. I can get it to work should there only be one user in the
group but I can't figure out how to select multiple records and then
loop through them inserting a new record for each one.

This is what i was trying to do:

CREATE TRIGGER add_privs ON [dbo].[tblPrivs] AFTER INSERT
AS

INSERT INTO tblUserGroups (userGroupGroup, userGroupUser,

insert 5 times creating a new record for each userID.

I'm possibly fast climbing the wrong tree but if someone could point
me towarsd the right one I'd be grateful :)

TIA

Rachel

2. D3/Linux install question

3. loop thru table multiple selects/inserts

4. Licensing

5. Insert,Update&Delete Record in Multiple Table

6. SQL Programer VS SQL Navigator

7. SELECTING records from multiple Tables

8. Program Global Area

9. Insert multiple records to child table from ASP page

10. Insert,Update,Delete Record in Multiple Table-URGENT

11. Insert,Update,Delete Record from Multiple Table

12. Insert Multiple .txt files to one table, 1file per record

13. Insert,Update,Delete Record in Multiple Table-URGENT