Hello Experts, I will like to ask if there's a way to add in a statement if 0 shows will be "success" and if a 1 shows would be "Cancelled" o.IsSkipcartCancelled as 'IsAdminCanceled', this is the line o.IsSkipcartCancelled as 'IsAdminCanceled', o.IsRetailerCancelled as 'IsRetailerCancelled', o.DescriptionOfRetailerCancel as 'OrderStateAtRetailerCancel', (SELECT top 1 ExceptionalEvent FROM JobEvents WHERE OrderId = O.OrderID and EventName = 'close_order') as 'ReasonCode', TRIM(ISNULL(d.FirstName, '') + ' ' + ISNULL(d.LastName, '')) as DriverName, Thanks
