In article <dfd4623d.0401161520.67a173c4_at_posting.google.com>,
cbrown_at_ghx.com says...
> I've got a SQL script with MIN and MAX analytic functions that works
> just fine all by itself but as soon as I try to compile a procedure
> using that same script it fails after the OVER saying it's looking for
> either ',' or 'from'. I'm by no means a guru but have compiled other
> procedures without analytic functions without any problem. Will 8.1.7
> accept an analytic function within a procedure?
>
> Any advice or information....???? Thanks
>
> The procedure follows:
>
<snip>
Put your analytical function queries in a view and call the view from
your proc. Might be better practice anyway.
Received on Sun Jan 18 2004 - 03:58:22 CST
