Re: Stored procedure to find record with max values, help!!

ccliu wrote: I think what you want is: select ... into ... from LotJob where LotJobSequence = ( > SELECT MAX(LotJobSequence) > FROM LotJob > WHERE Lot = o_Lot > ); This is still like doing two queries and probably no faster, but at least its in one statement. -- Sincerly, Doug Wilson(dougw@amgen.com) *** The opinions expressed here are my own and not neccessarily *** *** that of a rational human being . . . ************* *** Disclaimer: These are the opinions of the poster not Amgen Inc.***