Posted by Steve on 11/30/05 04:16

No insult taken. Oh, well, I appreciate all quick feedback on the issue.
This is really a pretty civil group.

Best regards,
Steve Caldwell


Steve Jorgensen wrote:

> On Wed, 30 Nov 2005 00:26:33 GMT, Steve <sjc4914@yahoo.com> wrote:
>
>>This is a "commercial" database solution purchased to record and report
>>environmental data. I don't like the design for all the reasons already
>>posted, and more. Though I had nothing to do with the selection,
>>unfortunately, I am charged with completing a task, so like it or not, it
>>is on my plate.
>
> Sorry - didn't mean to insult your intelligence. It helps to add a
> disclaimer about not having control of the design, so people will know to
> answer what you ask, not the red flag you can't do anything about.
>
>>Terry Kreft's idea looks workable, but not optimum. It would seem like
>>there would be a way to get around pasting strings together and then
>>executing the string. I was wondering if there was a way to use a subquery
>>to return a table reference. It is a rather obtuse way of getting there,
>>and I haven't investigated it yet. Any alternate solutions anyone can
>>think of?
>
> A subquery won't help because that's just another query that returns data
> from
> the objects it was written to return data from (and no others).
> Basically, to do what you need to do, you have to use some kind if Dynamic
> SQL which is another name for "pasting strings together and then executing
> the string".
>

[Back to original message]