Re: returning a constant set of numbers from a "select"

From: p! <p!_at_unix.ndo.co.uk>
Date: Mon, 21 Jul 2003 13:42:36 GMT
Message-ID: <3f1bed32.17401140@news>

On Mon, 21 Jul 2003 14:20:15 +0100, "Alan Mills" <Alan.Mills_at_xservices.pants.fujitsu.com> wrote:

>
>"p!" <p!@unix.ndo.co.uk> wrote in message news:3f1be5ed.15540453_at_news...
>> hi,
>>
>> could anyone tell me how i can do the following:
>>

<snip>

Try that.
>
>

thanks for the quick reply Alan.

i cannot guarentee that any tables which will be big enough to cover all of the potential ranges (pot. as large as 20-30k numbers) will be granted to all users of the application, so could use an example which does not rely on tables. i was thinking something along the lines of selecting from a stored procedure - but havnt got a clue how to go about it - any ideas?!

thanks,
p! Received on Mon Jul 21 2003 - 08:42:36 CDT