Multiple Inserts
Is there a way to do multiple inserts into a table at once based on the rows from a second table (using a sp)?
I have tables: users, user preferences, and preference list. The preference list table is customizable by Admins. When we add a user to the system I want to add the user to the user table (this I have already), then add entries for that user to the user preferences table FOR EACH row in the preferences list table that is flagged.
Make sense?
-------------------------
Beware of programmers with screwdrivers...
__________________
-------------------------
Beware of programmers with screwdrivers...
|
