Posted by mcolson on 08/01/07 13:04

On Jul 31, 10:29 pm, shiju <shiju.sam...@gmail.com> wrote:
> On Aug 1, 2:45 am, mcolson <mcolson1...@gmail.com> wrote:> 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
>
> I think this is what looking
>
> select @outytd=outytd,@outmtd=outmtd
> from mytable where IDnum = (select
> (max(IDnum)) from mytable)

that was exactly what I needed. Thanks

• Next in forum: Re: Pass Table as a parameter to a function
• Prev in forum: Re: output parameters from row with max id
• Thread view: Re: output parameters from row with max id

[Reply to this message]