Trying to convert number range (1-5) to numerical progression (1,2,3,4,5)

Question

Trying to convert number range (1-5) to numerical progression (1,2,3,4,5)

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 1

Thanks for the feedback, Tony. And, anyone who wants to learn more about how a Tally table works to replace some loops, here's a pretty good (heh... if I do say so myself) article on how they work...

[font="Arial Black"]The "Numbers" or "Tally" Table: What it is and how it replaces a loop.[/font][/url]

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

sgmunson SSC Guru Points: 110640 More actions · Answer 2

Interesting data here. Anyone know what to do with the repeating occurrences of several of the ranges because there are "locations" that may or may not be "AADC"s, but are on the list? Not sure if one would need a separate field to designate items as AADC, FCM, or "PER,STD", or perhaps both PER and STD? Anyone able to satisfy my curiousity?

Steve

(aka smunson)

:):):)

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 3

I don't know which would be preferred, which is why I didn't dupe check them into oblivion.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)