RE: Numbering rows in SQL result set

So did I... I tested it right before your post arrived! <vbg>

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: CWilt@xxxxxxxxxxxx [mailto:CWilt@xxxxxxxxxxxx]
Sent: Wednesday, May 05, 2004 12:06 PM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: Numbering rows in SQL result set


Eric's right....guess I should have tested it before posting.

Sorry about that, thought it would work.

Charles


> -----Original Message-----
> From: DeLong, Eric [mailto:EDeLong@xxxxxxxxxxxxxxx]
> Sent: Wednesday, May 05, 2004 12:54 PM
> To: 'Midrange Systems Technical Discussion'
> Subject: RE: Numbering rows in SQL result set
> 
> 
> Nope, you still get the RRN of the original dataset, not the 
> temp result
> set.....
> 
> Eric DeLong
> Sally Beauty Company
> MIS-Project Manager (BSG)
> 940-898-7863 or ext. 1863
> 
> 
> 
> -----Original Message-----
> From: CWilt@xxxxxxxxxxxx [mailto:CWilt@xxxxxxxxxxxx]
> Sent: Wednesday, May 05, 2004 11:45 AM
> To: midrange-l@xxxxxxxxxxxx
> Subject: RE: Numbering rows in SQL result set
> 
> 
> This would work....
> 
> with TmpTable as                                                      
>         (select name greatones )
> select rrn(TmpTable), name
> from TmpTable
> 
> 
> Only problem would be if you wanted to use an "order by name" 
> it would need
> to in the TmpTable select and I'm not positive that that is allowed.
> 
> May want to look in the archives for other ideas, I seem to 
> remember this
> coming up before.
> 
> HTH,
> Charles
> 
> > -----Original Message-----
> > From: meovino@xxxxxxxxxxxxxxxxx [mailto:meovino@xxxxxxxxxxxxxxxxx]
> > Sent: Wednesday, May 05, 2004 10:32 AM
> > To: Midrange Systems Technical Discussion
> > Subject: Numbering rows in SQL result set
> > 
> > 
> > Is there an SQL scalar function or some other trick I can use 
> > to add a 
> > column to a result set that numbers the rows in the set.  
> > Let's say my 
> > result set currently is:
> > 
> > John
> > Paul
> > George
> > Ringo
> > 
> > I want it to look like:
> > 
> > 1   John
> > 2   Paul
> > 3   George
> > 4   Ringo
> > 
> > Thanks!
> > 
> > Mike E.
> > 
> > _______________________________________________
> > This is the Midrange Systems Technical Discussion 
> > (MIDRANGE-L) mailing list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
> > 
> _______________________________________________
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
> 
> _______________________________________________
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.