Re: is there a simpler way to do this?

Okay, thanks guys. This one looks so obvious now, but I couldn't find it in the newsgroups. SQL Server handles "select into" only with tables.

Keith

Jeff Piatt <member25196_at_dbforums.com> wrote in message news:<2560987.1045883724_at_dbforums.com>...
> Yes, use a singleton select (select... into...) along these lines:
>
> declare
> n_ID daily_changes.change_ID%TYPE;
> begin
> select max(change_ID)
> into n_ID
> from daily_changes
> where daily_id = 1;
> dbms_output.put_line(n_ID);
> end;
Received on Sat Feb 22 2003 - 21:18:21 CET