Thanks for your help.
We are writing a web application that displays this kind of data (but
obviously not as simplified) and for a large number of tables. Many of
the select statements will be joins across a few tables. I think your
approach is very impressive but overly complicated for reuse
throughout our application.
We may have to reconsider a rework of the tables or use a stored
procedure.
But it was useful to see this technique so that it is available to us
if we change our minds (and we would probably use it in a View).
Joe
Received on Fri Feb 20 2004 - 08:33:06 CST
