>>But have you been able to get my query to work?
>>
>>select * from (select *, row_Number() OVER (partition by BatchID Order BY ActionDate) as RowNum from returns) R
>>where RowNum = 1
>
>
>That did it!! Thank you!!!
As my former colleague and boss would say: "FINALLY!" :))))))))))))
If it's not broken, fix it until it is.
My Blog