Trigger - Convert Interbase To MS SQL Server

Hello,

I'm converting an Interbase database to a MS SQL database.

I have three tables:

TableA: Contains a number of records that represent a tasks to be performed (i.e. tasks on a construction job site).

TableB: Job File

TableC: Tasks to be performed for a specific job.

When a new record in TableB is added, I would like a trigger (after insert trigger) to copy the records from TableA into TableC.

Table Structures:

TableA:
TaskID: integer
Description: varchar(50)
Deleted: bit

TableB:
JobID: integer
Description: varchar(50)

TableC:
JobTaskID: integer
JobID: integer
TaskID: integer
IsCompleted: bit

create trigger TableB_AfterInsert
on TableB
After Insert
As
Declare @TaskID integer
Begin

For Select TaskID From TableA
Where Deleted = 0
Into @TaskID
do begin
insert into TableC (JobID, TaskID) Values (inserted.JobID, @TaskID);
end;

End

This is my attempt to convert from Interbase

Thanks,

Steve