I always use stored procedure when I meet such demand.
On Jan 3, 2008 11:09 PM, Baron Schwartz <[EMAIL PROTECTED]> wrote:
> Hi,
>
> On Jan 3, 2008 9:28 AM, GF <[EMAIL PROTECTED]> wrote:
> > I need to create a view, about a ranking.
> > The select from which I generate the view has a "ORDER BY" a
Hi,
On Jan 3, 2008 9:28 AM, GF <[EMAIL PROTECTED]> wrote:
> I need to create a view, about a ranking.
> The select from which I generate the view has a "ORDER BY" and I need
> to have a column in that select that shows the position of the object
> in that ranking.
>
> I have searched on google, an
I need to create a view, about a ranking.
The select from which I generate the view has a "ORDER BY" and I need
to have a column in that select that shows the position of the object
in that ranking.
I have searched on google, and I have found that it's possibile to do
it using the SET command and