Re: VIEW and ROW_NUMBER

2008-01-04 Thread Moon's Father
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

Re: VIEW and ROW_NUMBER

2008-01-03 Thread Baron Schwartz
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

VIEW and ROW_NUMBER

2008-01-03 Thread GF
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