>Now I get
>

>Msg 8156, Level 16, State 1, Procedure ap_GetReturnsForWarehouse, Line 23
>The column 'Status' was specified multiple times for 'OrderedResultS'.
>Msg 4104, Level 16, State 1, Procedure ap_GetReturnsForWarehouse, Line 23
>The multi-part identifier "OrderedResultSet.RowNum" could not be bound.
>Msg 4104, Level 16, State 1, Procedure ap_GetReturnsForWarehouse, Line 23
>The multi-part identifier "p.PartNo" could not be bound.
>Msg 4104, Level 16, State 1, Procedure ap_GetReturnsForWarehouse, Line 23
>The multi-part identifier "r.SerialNo" could not be bound.
>

>
>There are elements in that query I have never seen before. Very confusing.

The inner part ( with row_number() ) was supposed to be a derived table. I'm guessing you didn't use

select * from (derived table select with row_number()) OrderedRecordSet (alias I gave to the derived table) where rowNum = 1

Can you post your exact query now to correct ?