here is what I ran:

declare @flightId int

declare @flightTime DECIMAL(10,2)

declare @blockTime DECIMAL(10,2)

declare @ttEngine1 DECIMAL(10,2)

declare @tcEngine1 DECIMAL(10,2)

declare @ttEngine2 DECIMAL(10,2)

declare @tcEngine2 DECIMAL(10,2)

declare @ttAirframe DECIMAL(10,2)

declare @tcAirframe DECIMAL(10,2)

declare @profileName nvarchar(128)= 'I'

declare @To nvarchar(255) = 'to'

declare...

okay so i dropped that and am running the query but seems to take a while longer 59 secs so far

just spins with nothing happening

WHILE EXISTS (

SELECT *

FROM flightsClosed as a

inner JOIN flightsClosed2 b

ON a.FlightID = b.FlightID

WHERE a.StatusTypeID != b.StatusTypeID

AND a.StatusTypeID = 44 --returns 2 rows that are different

)

BEGIN

--PRINT 'changes...

lol - thanks

I change to an inner join and did the following after the declares.

DECLARE @rowcount INT

SET @rowcount = (select @flightId = flightId,

@flightTime = FlightTime,

@blockTime = BlockTime,

@ttEngine1 =...