Selecting a range from mixed alpha-numeric column

Question

Post reply

Selecting a range from mixed alpha-numeric column

Viewing 8 posts - 31 through 37 (of 37 total)

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

TraderSam SSCrazy Points: 2931 More actions · Answer 1

There is no range specified in the 5th query, so you should be getting all values.

If it was easy, everybody would be doing it!;)

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 2

Are you sure you set the partRange derived column to return Bigint values? Because your WHERE clause is acting like it's character data. (assuming you've actually put in a WHERE clause on the last recordset))

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

biscuit SSC Veteran Points: 247 More actions · Answer 3

Trader Sam (3/17/2008)
There is no range specified in the 5th query, so you should be getting all values.

I guess I should have looked at the code a little closer. you are right about the 5th query. Sorry for the flub.

And thanks to all for the great solutions.

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 4

Heh... "Always look eye, Angisan..."

--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)

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 5

Jeff Moden (3/17/2008)
Heh... "Always look eye, Angisan..."

So I'm NOT the only one quoting Pat Morita....:)

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 6

Mixed bag, actually... some of it is from ShoGun...

--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)

TraderSam SSCrazy Points: 2931 More actions · Answer 7

biscuit (3/17/2008)
Sorry for the flub.

Don't worry about it ... we all have our moments. That's why it helps having so many sets of eyes on here to look at things.

If it was easy, everybody would be doing it!;)

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 8

Trader Sam (3/17/2008)
biscuit (3/17/2008)
Sorry for the flub.
Don't worry about it ... we all have our moments. That's why it helps having so many sets of eyes on here to look at things.

"Z'actly" 😉

--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)