From: David Vallner <david@...>
Date: 2006-12-21T09:14:06+09:00
Subject: Re: string of strings...

--------------enig444FE6AAB5C57281FEBB55CA
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Robert Klemme wrote:
> A completely different option is to create a temp table (depends on you=
r
> DB whether and how that is done), put all the values in that temp table=

> and join it against the table you are querying.
>=20

Talk about serendipity... I was looking for a way to avoid having to do
either any sort of query string building (which I hate) or multiple
SELECTS (for obvious reasons) for a WHERE ... IN situation for work
stuff, and this one sounds quite nifty. Would the performance of that be
comparable to using a WHERE ... IN?

David Vallner


--------------enig444FE6AAB5C57281FEBB55CA
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (MingW32)

iD8DBQFFidHIy6MhrS8astoRAk8oAJ9qwvHQxVaWgcymheNIOk6NrfzLAgCeNxSw
+CEEUDZNQmquHQGbzzz7wL4=
=YMhA
-----END PGP SIGNATURE-----

--------------enig444FE6AAB5C57281FEBB55CA--