quote:

---

Originally posted by atmonline

INSERT INTO ResumesReceived (
JS_UserID,
JobID,
ProfileID,
DateReceived,
PaperApplied,
Evaluationstepid
)
SELECT
JobSeekerID,
JobNO,
ProfileID,
ReqDate ,
1,
es.EvaluationStepid

FROM #t2 a left join #t1 b ON (a.seq=b.seq)
left join ExamPlanJobMat em ON (em.jobid = b.JobNO)
left join Evaluationsteps es ON (es.examplanid = em.examplanid)
where es.EvaluationStepTypeID = 1


i am using the above query to insert records into the ResumesReceived table.This table has a trigger that insert new record to another table called Candidatesteps.

My problem is if i insert for example 10 records only the first record is being added to the CandidateSteps.

so now i am disabling the trigger and running a query to add records to the candidatesteps.

---

quote:

---

My problem is if i insert for example 10 records only the first record is being added to the CandidateSteps

---

insert into Candidatesteps ( . . . )
select  . . .
from    inserted i

quote:

---

Originally posted by atmonline

The following is the trigger in resumesreceived table


set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


ALTER TRIGGER [ins_ResumesReceived] ON [dbo].[ResumesReceived]
FOR INSERT
AS
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
/*
damir - 09/01/02 - this TRIGGER inserts a row into CandidateSteps table to step the applicant
to 'Application Received' step.
*/
DECLARE @ResumeReceivedID INT
DECLARE @JobID INT
DECLARE @EvaluationStepID INT

SELECT @JobID= ins.JobID,
@ResumeReceivedID= ins.ResumeReceivedID
FROM inserted ins

/* if Exam Plan is set up for this job perform an insert */
SELECT @EvaluationStepID = es.EvaluationStepID
FROM EvaluationSteps es, ExamPlanJobMat ejmat
WHERE es.EvaluationStepTypeID = 1
AND es.ExamPlanID = ejmat.ExamPlanID
AND ejmat.JobID = @JobID


IF @EvaluationStepID > 0
BEGIN
INSERT INTO CandidateSteps
( ResumeReceivedID
,EvaluationStepID
,CreatedDate
,LastUpdatedDate )

VALUES ( @ResumeReceivedID
,@EvaluationStepID
,GetDate()
,GetDate() )


END

---