Re: Line Numbers in SQL

From: Ray Higdon (sqlhigdon_at_nospam.yahoo.com)
Date: 02/16/04 

Date: Mon, 16 Feb 2004 13:10:06 -0500

Nothing there? I just went to it, it's toward the bottom of the page, search
for "reporting services" 

-- 
Ray Higdon MCSE, MCDBA, CCNA
---
"Scott Meddows" <scott_meddows_no_spm@tsged-removeme.com> wrote in message
news:uVp1YYL9DHA.2712@tk2msftngp13.phx.gbl...
> 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.
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>