Triggers or T-SQL?

[remember]

I am trying to make notification system for my website:This is the table structure\[code\]notification ----------------- id (pk) userid notification_type (for complexity like notifications for pictures, videos, apps etc.) notification time\[/code\]Now my understanding is that when a notification is added, we need to find the users friends and insert all those rows in the \[code\]notification\[/code\] table right ? If this is correct, then, what would be the best way to achieve this ?\[code\]1.Triggers?2.Write T-SQL (sql query in server side) to Select all the friends and then use SQL bulk copy?\[/code\]