SQL Server 2012

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table tblUPStrackinghistory(trackingnumber varchar(10), intmontyorderid int,
event_status_description varchar(10), event_date_time datetime)
insert into tblUPStrackinghistory values
('A', 4, 'something', '2020-03-02 10:30:00'),
('A', 4, 'origin',    '2020-03-10 10:30:00'),
('A', 4, 'something', '2020-03-15 10:30:00'),
('B', 3, 'something', '2020-03-11 10:30:00'),
('B', 3, 'something', '2020-03-13 10:30:00')
5 rows affected

SELECT Distinct (RTRIM(trackingnumber) + LTRIM(CAST(intmontyorderid AS varchar))) AS OrderTrack,
    COALESCE(MIN(CASE WHEN event_status_description like '%origin%' THEN event_date_time END), MIN(event_date_time)) AS OriginDate
-- INTO #OriginTable
FROM tblUPStrackinghistory
GROUP BY trackingnumber, intmontyorderid


OrderTrack
OriginDate


A4
10/03/2020 10:30:00

B3
11/03/2020 10:30:00


Warning: Null value is eliminated by an aggregate or other SET operation.