I have a table which gets new rows inserted on a daily basis via a scheduled job. I want to send one email with all inserted records for a particular day using trigger. Could somebody help me in how to create a trigger for multiple inserts on a table?
So you only want to send one email, once the job that inserts the data is finished?
Capture the inserted records into another table (by trigger or stored proc, or whatever you want), then add another step to the job to simply email you, creating the body of the email with the records.
Turn on Change Data Capture on the table, so that you can easily query for the inserted records in a stored procedure that you run (through a SQL Agent Job) once a day.
Kev Riley's answer is a very good option.
Another option you can consider is to not use a trigger at all but instead add a timestamp column. You can then write a stored procedure to select, format, and e-mail all rows created within the past 24 hours and set that on an SQL Server Agent Job. I used a technique like this to send management daily reports before.
