SORRY FOR INTERRUPT THIS THE STORED PROCEDURES
CREATE PROCEDURE [dbo].[1400-88]
@FROM DATE ,
@TO DATE ,
@TYPE_ASSESSMENT NVARCHAR(50),
@BASE_WING NVARCHAR(50),
@SQUADRON NVARCHAR(50),
@FLIGHT_STAFF NVARCHAR(50),
@BRANCH NVARCHAR(50),
@WORK_CENTER NVARCHAR(50),
@REPEAT NVARCHAR(50),
@MAJOR NVARCHAR(50),
@SAFETY NVARCHAR(50),
@MINOR NVARCHAR(50),
@SPECIAL NVARCHAR(50),
@AQLA NVARCHAR(50),
@OTHER NVARCHAR(50),
@REPORT_CONTROL NVARCHAR(50),
@OBSERVATION NVARCHAR(50),
@REFERENCE NVARCHAR(50),
@MOST_PROBABLE_CAUSE NVARCHAR(50),
@REFERENCE_AS_APPROPERIATE NVARCHAR(50),
@RECOMMANDED_CORRECTIVE_ACTION NVARCHAR(50),
@QMA_CHECKLIST_TASK# NVARCHAR(50),
@INSPECTOR_INFO NVARCHAR(50),
@INTERVAL NVARCHAR(50),
@CORRECTIVE_ACTION NVARCHAR(500),
@OPR NVARCHAR(10),
@CORRECTED_BY NVARCHAR(20),
@DATE_CORRECTED DATETIME
AS
BEGIN
INSERT INTO [1400-88-QAR]
([DATE FROM]
,[DATE TO]
,[TYPE ASSESSMENT]
,[BASE-WING]
,[SQUADRON]
,[FLIGHT/STAFF]
,[BRANCH]
,[WORKCENTER]
,[REPEAT]
,[MAJOR]
,[SAFETY]
,[MINOR]
,[SPECIAL]
,[AQLA]
,[OTHER]
,[REPORT CONTROL #]
,[OBSERVATION]
,[REFERENCE]
,[MOST PROBABLE CAUSE]
,[REFERENCE (as APPROPERIATE)]
,[RECOMMENDED CORRECIVE ACTION]
,[QMA CHECKLIST TASK #]
,[INSPECTOR INFO]
,[INTERVAL]
,[CORRECTIVE_ACTION]
,[OPR]
,[CORRECTED_BY]
,[DATE_CORRECTED])
VALUES
(@FROM
,@TO
,@TYPE_ASSESSMENT
,@BASE_WING
,@SQUADRON
,@FLIGHT_STAFF
,@BRANCH
,@WORK_CENTER
,@REPEAT
,@MAJOR
,@SAFETY
,@MINOR
,@SPECIAL
,@AQLA
,@OTHER
,@REPORT_CONTROL
,@OBSERVATION
,@REFERENCE
,@MOST_PROBABLE_CAUSE
,@REFERENCE_AS_APPROPERIATE
,@RECOMMANDED_CORRECTIVE_ACTION
,@QMA_CHECKLIST_TASK#
,@INSPECTOR_INFO
,@INTERVAL
,@CORRECTIVE_ACTION
,@OPR
,@CORRECTED_BY
,@DATE_CORRECTED)
SELECT SCOPE_IDENTITY() -- 1400-88
END