I am new to SQL Server world. So please help me out.
I have a table with employee details and total salary (Table : Emp_Det).
Also there is another table called Salary split (Table: Sal_Det). I have created a trigger on the first table (Emp_Det) Which takes the total salary from the table and updates/inserts the Sal_Details table.
Now when I do a bulk insert from using (insert into select statement) I get the salary details of only the last employee in the other table.
Is that the trigger is fired after all the inserts or is it done at row level.