Re: Line Numbers in SQL

From: Scott Meddows (scott_meddows_no_spm_at_tsged-removeme.com)
Date: 02/16/04


Date: Mon, 16 Feb 2004 11:55:41 -0600

Nothing there, either..

Doesn't come up in search.

"Ray Higdon" <sqlhigdon@nospam.yahoo.com> wrote in message
news:eKr4rHL9DHA.400@tk2msftngp13.phx.gbl...
> See here - http://www.microsoft.com/sql/community/newsgroups/default.asp
>
> --
> Ray Higdon MCSE, MCDBA, CCNA
> ---
> "Scott Meddows" <scott_meddows_no_spm@tsged-removeme.com> wrote in message
> news:%23k0kO%23K9DHA.4060@tk2msftngp13.phx.gbl...
> > I don't seem to have a message with that title and the newsgroup is not
in
> > Google groups yet...
> >
> > "Jean Philippe Vankemmel" <vankemjp@ifrance.com> wrote in message
> > news:%23zh0zZG9DHA.452@TK2MSFTNGP11.phx.gbl...
> > > you should have a look at the subject "row style in matrix" in
> > > microsoft.public.sqlserver.reportingsvcs
> > > Jean-Philippe.
> > >
> > > "Scott Meddows" <scott_meddows_no_spm@tsged-removeme.com> a écrit dans
> le
> > > message de news:eDztD6e8DHA.2404@TK2MSFTNGP12.phx.gbl...
> > > > It's the only way I can think of to alternate row colors in
reporting
> > > > services....
> > > >
> > > > "Ray Higdon" <sqlhigdon@nospam.yahoo.com> wrote in message
> > > > news:%233NMuic8DHA.1548@tk2msftngp13.phx.gbl...
> > > > > No, you could do something with a temp table and IDENTITY. I
believe
> > > Yukon
> > > > > has the rownumber function. What do you need it for?
> > > > >
> > > > > --
> > > > > Ray Higdon MCSE, MCDBA, CCNA
> > > > > ---
> > > > > "Scott Meddows" <scott_meddows_no_spm@tsged-removeme.com> wrote in
> > > message
> > > > > news:uTDWhna8DHA.1052@TK2MSFTNGP12.phx.gbl...
> > > > > > Is there a function I can put into my select clause that tell me
> > what
> > > > the
> > > > > > line number of the row is?
> > > > > >
> > > > > > i.e. in Oracle you can do something like (Been a year since I've
> > used
> > > > > > Oracle)
> > > > > >
> > > > > > select rownum, Field1, Field2
> > > > > > from blah
> > > > > >
> > > > > > Any help is appreciated. Thanks.
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>



Relevant Pages

  • Re: SQL Injectors
    ... >That top link by nexgenss is pretty comprehensive. ... >Ray Higdon MCSE, MCDBA, CCNA ...
    (microsoft.public.sqlserver.security)
  • Tables security
    ... Ray Higdon MCSE, MCDBA, CCNA ... (if use Sql Server enterprise manager can not ...
    (microsoft.public.sqlserver.security)
  • Re: Parameters question
    ... >Ray Higdon MCSE, MCDBA, CCNA ... I changed the query to the following. ...
    (microsoft.public.sqlserver.programming)
  • Re: Books for SQL Analysis Server
    ... "Ray Higdon" wrote in message ... >> Ray Higdon MCSE, MCDBA, CCNA ...
    (microsoft.public.sqlserver.olap)
  • Re: Over-Protected
    ... Ask your network or DBA's to restore a backup for you. ... Ray Higdon MCSE, MCDBA, CCNA ...
    (microsoft.public.sqlserver.security)