Re: dynamic column name
From: Mark <markg_at_mymail.co.uk>
Date: 10 May 2002 06:34:49 -0700
Message-ID: <ddb31653.0205100534.783560c8_at_posting.google.com>
Date: 10 May 2002 06:34:49 -0700
Message-ID: <ddb31653.0205100534.783560c8_at_posting.google.com>
You can use Dynamic SQL to create your query. Once submitted, again use Dynamic SQL to run your other query and process results.
Hope i havent confused u!
M
"M Green" <machiel2000_at_spam.home.nl> wrote in message news:<0cKC8.212635$oI.14514377_at_zwoll1.home.nl>...
> Hi All,
>
> I've looked around for the answer to my question but couldn't find a
> straight answer.
>
> Question:
> Can I use the result of a query as the column name in another query?
>
> Something like:
> SELECT (SELECT column FROM columns WHERE column like '%TEST') FROM table
>
> Thanks very much!
> Mick Green
Received on Fri May 10 2002 - 15:34:49 CEST