tracking.sql

DECLARE @ConsigneeName varchar(100);
SET @ConsigneeName =  (SELECT top 1 CONCAT(DLName, ' ', DLCity, ', ', DLState) FROM tagnet_AppointmentSPN_Orders
WHERE JobType = 'DELIVERY' AND OrderState NOT IN (10)
AND PartnerPrimaryOrderID = '213U67560');

DECLARE @AttemptDate datetime;
SET @AttemptDate =  (SELECT MIN(PUActualArrive) FROM tagnet_AppointmentSPN_Orders
WHERE JobType = 'ATTEMPT' AND OrderState NOT IN (10)
AND PartnerPrimaryOrderID = '213U67560');

SELECT @ConsigneeName as [Consignee:], @AttemptDate [Attempted Pickup:]