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...

Thanks u all. That helped

Thanks for trying to answer my queries. To Seans' questions...

You have two rows here and one of them is the OriginalAircraftNumber and one becomes the FinalAircraftNumber. What can you use...

Yes, I want to GROUP BY on the first 7 columns. However, I'm not sure if that will resolve my issue.

In my above example, here are the scenarios,

- if I...

This issue has been resolved. Our DBAs added another column and that gives us what we were looking for.

Thanks for all of your comments.

Thanks Sean. This helped me to get what I was looking for now. I'll keep your suggestion for the future posts.

Once again thanks so much