> Yes. If you create a table with all of the values, 1 to 100,000+, and then
> join that with lookup_data, using a "left outer join", and then use a
> case statement for the value -- when NULL, 'Unknown', then it should
> work.
This would still require constructing a large table, which is wha
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 27 February 2004 2:18 pm, JJ Gabor wrote:
> Hello all,
>
> I have a lookup table consisting of 100,000+ rows.
>
> 99% of the lookup values resolve to 'Unknown'.
>
> Building the lookup table takes a long time.
>
> I would like to remove the '
Hello all,
I have a lookup table consisting of 100,000+ rows.
99% of the lookup values resolve to 'Unknown'.
Building the lookup table takes a long time.
I would like to remove the 'Unknown' entries from the
table and provide a VIEW to emulate them.
The VIEW would need to provide all 100,000+
