Declare @Table Table (OrderNo int, [LineNo] int, Product varchar(50), Result varchar(50))

Insert Into @Table
Select 1,1, 'ABC', NULL UNION ALL
Select 1,2, 'XYZ', 'Requires Review' UNION ALL
Select 2,1, 'FooBar', NULL UNION ALL
Select 2,2, 'ID10t', NULL 


Select * from @Table
where OrderNo Not IN 
  (Select OrderNo From @Table Where Result IS NOT NULL)

create table #Orders (
    OrderNum int,
    LineNum int,
    Product varchar(10),
    Result varchar(25)
)
;
insert into #Orders
select 1,1,'ABC',null union all
select 1,2,'XYZ','Requires Review' union all
select 2,1,'Foobar',null union all
select 2,2,'Id10t',null
;

select * from #Orders;

with OrderResults(
    OrderNum
) as (
select distinct
    OrderNum
from
    #Orders
where
    Result is not null
)
select
    o.OrderNum,
    o.LineNum,
    o.Product,
    o.Result
from
    #Orders o
    left outer join OrderResults ors
        on (o.OrderNum = ors.OrderNum)
where
    ors.OrderNum is null;

drop table #Orders;

create table #Orders (
    OrderNum int,
    LineNum int,
    Product varchar(10),
    Result varchar(25)
)
;
insert into #Orders
select 1,1,'ABC',null union all
select 1,2,'XYZ','Requires Review' union all
select 2,1,'Foobar',null union all
select 2,2,'Id10t',null union all
select 3,1, 'ABC', 'Not Null' union all
select 3,2, 'DEF', 'Not Null'
;

-- Get the orders where all Result is null
SELECT OrderNum
FROM #Orders
GROUP BY OrderNum
HAVING COUNT(Result) = 0

-- You can also get all of the orders that don't
-- have any nulls in Result
SELECT OrderNum
FROM #Orders
GROUP BY OrderNum
HAVING COUNT(*) - COUNT(Result) = 0