ayuda obtener un solo registro de dos consultas????

[flaviovich]

Intenta poniendo tu segunda consulta como subconsulta:

Código sql:

SELECT 
RTRIM(SUBSTRING(field1,1,6)) AS Bat,
RTRIM(SUBSTRING(field1,13,8)) AS Total,
RTRIM(SUBSTRING(field1,21,10)) AS Has,
RTRIM(SUBSTRING(field1,31,18)) AS TotalA,
(SELECT 
RTRIM(CONVERT(datetime,SUBSTRING(field1,71,8),100) ) AS ProcessD
FROM dbo.IMLoad AS C
WHERE SEQUENCE IN (SELECT MIN(SEQUENCE) FROM dbo.IMLoad AS D WHERE field0='5'))
FROM dbo.IMLoad AS A
WHERE SEQUENCE IN (SELECT MIN(SEQUENCE) FROM dbo.IOMLoad AS B WHERE field0='9')
 

Pero lo mejor seria buscar algo en comun entre tus dos consultas.