,CTE4 as
  (
  Select distinct *
  , case when [Dispatch_Part_Commodity_List] = ltrim(Rtrim([Original Order])) then 1 else 0 end as'Same Part Repeat'
  , case When isnull([Dispatch_Part_Commodity_List], '') = '' or isnull([Original Order], '') = '' then 1 else 0 end as 'Labor Only Repeat'
  , Case When [Dispatch_Part_Commodity_List] != ltrim(Rtrim([Original Order])) then 1 else 0 end as 'Non Original Order'
  , Case When [Dispatch_Part_Commodity_List] like Concat ('%',ltrim(Rtrim([Original Order])),'%') then 1 else 0 end as 'Standby Flag'
  from Dispatch_Map
  where Row_Count = 1
  )