Re: Temp tables??

From: Michael J. Ort <michael_ort_at_my-deja.com>
Date: Thu, 05 Oct 2000 14:33:37 GMT
Message-ID: <8ri3g1$4ik$1@nnrp1.deja.com>

Rob,

Since everyone else has addressed the answer to your questions about native dynamic SQL and temporary tables, I will not repeat. I did notice however the below passage, and realizing that you are a SQL*Server guy, I suggest that you take a look into Oracle's CONNECT BY SQL verb. This may help you to get it into a 'simple SQL statement'.

HTH,
Michael J. Ort

In article <39db7fd8$0$28308_at_wodc7nh0.news.uu.net>, "Rob Gravereaux" <rgravereaux_at_mbcnet.com> wrote:

> The records can't be retrieved with a simple SQL statement - The code
> needs to 'walk' up a self-referenced table and do some weird
> comparisons to find the correct rows.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 05 2000 - 09:33:37 CDT