SELECT     detail_record.ticket_number, detail_record.division, detail_record.pickup_weight, CAST(detail_record.pickup_dt AS datetime) AS PickupDate, 
                      CAST(detail_record.deliver_dt AS datetime) AS DeliverDate, detail_record.customer_delv_to, detail_record.customer_bill_to, 
                      cmBillTo.customer_number AS bill_to_number, cmBillTo.customer_name AS bill_to_name, cmBillTo.city AS bill_to_city, 
                      cmDelvTo.customer_number AS deliver_to_number, cmDelvTo.customer_name AS deliver_to_name, cmDelvTo.city AS deliver_to_city, 
                      detail_record.pickup_date, detail_record.grand_total_wt, hauler_master.hauler_number, detail_record.ddp_weight AS LoadPounds
FROM  detail_record INNER JOIN
                      customer_master AS cmBillTo ON detail_record.customer_bill_to = cmBillTo.customer_number INNER JOIN
                      customer_master AS cmDelvTo ON detail_record.customer_delv_to = cmDelvTo.customer_number INNER JOIN
                      hauler_master ON detail_record.hauler_number = hauler_master.hauler_number
WHERE     (detail_record.pickup_date BETWEEN @start_date AND @end_date) AND (detail_record.customer_bill_to = @customer_number) OR
                      (detail_record.pickup_date BETWEEN @start_date AND @end_date) AND (detail_record.customer_delv_to = @customer_number)
ORDER BY detail_record.pickup_date