Ok so here is the revised posting.
USE [db_ABC]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
---Create a sample table
CREATE TABLE [dbo].[DeptArrival](
[FlightNumber] [int] NOT NULL,
[ScheduleDeptDate] [datetime] NOT NULL,
[ActualArrivalDay] [tinyint] NULL,
[ActualArrivalDate] [datetime] NULL
) ON [PRIMARY]
GO
--Insert some...