Trigger for each row

I have written a trigger for inserting data by each row in the foreign table depending on the inserted table.

Trigger is like this.

create trigger LkpElement_Insert
on LkpElement
for INSERT
as
IF EXISTS (SELECT * FROM inserted)
begin
declare @EID int
declare @ALRMCNT bigint
SELECT @EID = ELEMENT_ID FROM Inserted
SELECT @ALRMCNT = ALARM_COUNT FROM AlarmModelCount LEFT JOIN Inserted ON Inserted.ELEMENT_NAME = AlarmModelCount.ELEMENT_NAME

insert into ElementAlarms(ELEMENT_ID,date,ALARMCOUNT)
values(@EID,GETDATE(),@ALRMCNT )
end
But problem is only last row is inserted i.e depending on the inserted table.
Can anyone please tell me asap.

You can treat "inserted" as a regular table, so don't use a VALUES list but simply a SELECT query.

create trigger LkpElement_Insert
on LkpElement
for INSERT
as
IF EXISTS (SELECT * FROM inserted)
begin

INSERT INTO ElementAlarms(ELEMENT_ID, date, ALARMCOUNT)
SELECT inserted.ELEMENT_ID, GETDATE(), AlarmModelCount.ALARM_COUNT
FROM AlarmModelCount INNER JOIN Inserted
ON Inserted.ELEMENT_NAME = AlarmModelCount.ELEMENT_NAME

end

This is one of the annoyances in BOL: if you lookup INSERT, the first thing you find is the VALUES syntax, with no mention of the SELECT syntax.