"r" <r@r.com> wrote in message news:O2SbSrhNFHA.3668@TK2MSFTNGP14.phx.gbl...
> How can I create a column in a query that simply creates an number listing
> the order of the rows? Row 1 would contain 1, 2 would contain 2, etc. I
> need to sort a table based on a bunch of fields and then "rank" the
results.
>
> Thanks.
>
>
>

"Rohtash Kapoor" <rohtash_nospam@sqlmantra.com> wrote in message
news:eePf31hNFHA.2356@TK2MSFTNGP14.phx.gbl...
> Checkout the following link:
>
> How to dynamically number rows in a SELECT Statement
> http://support.microsoft.com/?kbid=186133
>
> ---
> Rohtash Kapoor
> http://www.sqlmantra.com
>
>
>
> "r" <r@r.com> wrote in message
news:O2SbSrhNFHA.3668@TK2MSFTNGP14.phx.gbl...
> > How can I create a column in a query that simply creates an number
listing
> > the order of the rows? Row 1 would contain 1, 2 would contain 2, etc.
I
> > need to sort a table based on a bunch of fields and then "rank" the
> results.
> >
> > Thanks.
> >
> >
> >
>
>