SELECT TOP 1 * FROM detail_record
WHERE ticket_number=SomeID

SELECT		detail_number,
		ticket_number,
		division,
		PickupDate,
		DeliverDate,
		customer_delv_to,
		customer_bill_to,
		bill_to_number,
		bill_to_name,
		bill_to_city,
		deliver_to_number,
		deliver_to_name,
		deliver_to_city,
		pickup_date,
		grand_total_wt,
		hauler_number,
		hauler_name,
		city,
		ddp_weight
FROM		(
			SELECT		detail_record.detail_number,
					detail_record.ticket_number,
					detail_record.division,
					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,
					hauler_master.hauler_name,
					hauler_master.city,
					detail_record.ddp_weight,
					ROW_NUMBER() OVER (PARTITION BY detail_record.ticket_number ORDER BY detail_record.detail_number DESC) AS recID
			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.customer_bill_to = @customer_number
					AND detail_record.pickup_date BETWEEN @StartDate AND @EndDate
		) AS d
WHERE		recID = 1
ORDER BY	ticket_number