Re: parsing a comma-separatinf list
> I would say that right now my top priority is to leave behind me code[color=blue]
> that is easy to understand and maintain. This is where OLAP functions
> are very handy. I love them.[/color]
I agree. The bonus with OLAP functions is they perform well over very
large result sets. The ANSI 92 equivalent won't.
[color=blue]
> I am less, if at all, concerned about portability and ANSI standards.[/color]
I'm more concerned with portability - but only between the major
vendors. ANSI appears to be a good way to get consistency in the
syntax across the vendors (there's nothing worse than seeing everyone
support a feature differently) - To me, the consistent nature of the
OLAP syntax is the best thing since vendors decided to support the
same outer join syntax.
> I would say that right now my top priority is to leave behind me code[color=blue]
> that is easy to understand and maintain. This is where OLAP functions
> are very handy. I love them.[/color]
I agree. The bonus with OLAP functions is they perform well over very
large result sets. The ANSI 92 equivalent won't.
[color=blue]
> I am less, if at all, concerned about portability and ANSI standards.[/color]
I'm more concerned with portability - but only between the major
vendors. ANSI appears to be a good way to get consistency in the
syntax across the vendors (there's nothing worse than seeing everyone
support a feature differently) - To me, the consistent nature of the
OLAP syntax is the best thing since vendors decided to support the
same outer join syntax.
Comment