SELECT        DeliveryNumber, PackageSize, PackageWeight, ServiceTypeCode, PickupDateTime, DeliveryDateTime, StatusCode
FROM            Delivery
GROUP BY DeliveryNumber, PackageSize, PackageWeight, ServiceTypeCode, PickupDateTime, DeliveryDateTime, StatusCode
HAVING        (DeliveryDateTime IS NULL) AND (404 = @Delivered) OR
                         (DATEDIFF(day, PickupDateTime, DeliveryDateTime) >= - 1) AND (DATEDIFF(day, PickupDateTime, DeliveryDateTime) <= 1) AND (DATEDIFF(day, PickupDateTime,
                         DeliveryDateTime) = @Delivered)