I am trying to select multiple values from the row with the max id,
and output them within my stored procedure. How would I combine the
following two rows so that I only need to use "from mytable where
IDnum = (select (max(IDnum)) from mytable))" once. I have at least 8
other outputs I will be setting and would like this to work more
efficiently than setting each individually... if possible.

set @outmtd = (select outmtd from mytable where IDnum = (select
(max(IDnum)) from mytable))
set @outytd = (select outytd from mytable where IDnum = (select
(max(IDnum)) from mytable))

Thanks for any help you can give

Matt

Please post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, data types, etc. in
your schema are. If you know how, follow ISO-11179 data element naming
conventions. Sample data is also a good idea, along with clear
specifications. It is very hard to debug code when you do not let us
see it.

On Aug 1, 2:45 am, mcolson <mcolson1... (AT) gmail (DOT) com> wrote:

select @outytd=outytd,@outmtd=outmtd
from mytable where IDnum = (select
(max(IDnum)) from mytable)

On Jul 31, 10:29 pm, shiju <shiju.sam... (AT) gmail (DOT) com> wrote:
that was exactly what I needed. Thanks