SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

ALTER      TRIGGER tr_InsertCR

ON view_InsertCR

Instead Of Insert

As

DECLARE @ReportID int;

DECLARE @SchoolID int;

DECLARE @OfficerID int;

DECLARE @DateOfVisit smallDateTime;

DECLARE @Hours  int;

DECLARE @Minutes int;

DECLARE @Activity int;

DECLARE @Funding int;

DECLARE @Reason  int;

DECLARE @Method  int;

DECLARE @Outcomes varChar(500)

SELECT @ReportID=intReportID From Inserted;

SELECT @SchoolID=intSchoolID From Inserted;

SELECT @OfficerID=intOfficerID...