Re: Several question about select.

Eitan wrote:
> Hello,
> I want a solutions for a compicateds sql select statments.
>
> The selects can use anything : views, stored procedures, analytic functions,
> etc...
> (not use materialized view, unless it is neccessary).

Lets stop right here. First I see you posted this to every usenet group you could spell. That is not going to make you a single friend and an apology is appropriate.

Second ... if you can use a Stored Procedure in a query I'd be fascinated to see you syntax.

I'd suggest following your apology to all you post a single new query asking for help in the appropriate group, c.d.o.server and actually explain what it is you are doing (WITH CLARITY) and include your version number. I'm not going to play guessing games with this.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)