InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 12:54:21 GMT20http://www.sqlservercentral.com/Forums/Topic1424162-149-1.aspx[quote][b]WiRL (2/27/2013)[/b][hr]Awesome that works.Many Thanks[/quote]Actually, it doesn't. If you insert more than one rrow into the table that fires the trigger, the trigger will only process one row. You need to rewrite the code in a set based fashion to get all of the rows. Please see Books Online (press the {f1} key) and read up on the INSERTED and DELETED logical tables that are available when the trigger is doing its job.It's also a pretty bad idea to call email in a trigger. If email is down, the trigger could fail which will rollback the external transaction. It's a far bettter thing to insert what you want into a staging table and have a job sweep through that tablee to send the emails.Wed, 27 Feb 2013 07:15:00 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic1424162-149-1.aspxAwesome that works.Many ThanksWed, 27 Feb 2013 04:52:07 GMTWiRLhttp://www.sqlservercentral.com/Forums/Topic1424162-149-1.aspxAlso beware the the inserted table can contain more than one row if a multiple row insert is done.Tue, 26 Feb 2013 10:20:27 GMTDavid Burrowshttp://www.sqlservercentral.com/Forums/Topic1424162-149-1.aspxTry this bit in the middle:SELECT @contact_id = contact_id,@staff_issued = staff_issuedFROM insertedThe inserted "table" contains the record you have inserted whilst contacts won't know which record you want.Tue, 26 Feb 2013 10:16:53 GMTRichard Warrhttp://www.sqlservercentral.com/Forums/Topic1424162-149-1.aspxHello All,I hope someone can help because I'm lost as to what the problem is...I have created a trigger:[code="sql"]CREATE TRIGGER new_contactON contactsFOR INSERTASdeclare @contact_id varchar(11)declare @body varchar(2000) declare @staff_issued varchar(10) SELECT @contact_id = contact_id,@staff_issued = staff_issuedFROM contacts SET @body = 'Customer with ID:' + @conatct_id + ' has been created by: ' + @staff_issued EXEC msdb.dbo.sp_send_dbmail @recipients = 'myemail@email.com',@subject = 'New Customer',@body = @body GO[/code]and then I run:[code="sql"]INSERT INTO contacts (contact_id, date_issued, staff_issued)VALUES ('ABC12345678', GETDATE(), 'ADMIN')[/code]The insert works, the triggers runs and emails me but it sends the top result from the table "contacts" rather than the one that has just inserted???I am obviously missing something.Can anyone point me in the right direction??Many Thanks in advanceTue, 26 Feb 2013 10:03:12 GMTWiRL