Good Morning Tim,

Hope your weekend was as enjoyable as mine!  

> << Thanks Tim. (Although don't ask me how to do the same thing in EDB at
> the moment ) <vbg>  >>
>
> Just use CREATE TEMPORARY TABLE..AS instead of SELECT..INTO.   Then just
> refer to the temporary table in the subsequent queries, and be sure to
> DROP the temporary table when you're done.

Doesn't sound too hard. Guess just a little bit of a learning curve for me
to work with.

Out of curiosity, why the change to this anyway? Does this meet more of an
industry standard, or does it have to do with additional features?

Cheers

Adam

Adam,

<< Hope your weekend was as enjoyable as mine!  >>

Uh, not really.  I got to paint the kids' rooms since they hadn't been done
in a while and they needed an update to reflect the fact that they're not in
elementary school anymore.   They don't call it Labor Day weekend for
nothing here in the States.

<< Out of curiosity, why the change to this anyway? Does this meet more of
an industry standard, or does it have to do with additional features? >>

CREATE TABLE..AS is industry standard, plus 1.06 will implement the standard
INTO behavior, which is to put the contents of a single-column, single-row
SELECT query into an output parameter that can be retrieved by the calling
session.

--
Tim Young
Elevate Software
www.elevatesoft.com