overlap query where to and from can be same ( of next and previous range)

Question

overlap query where to and from can be same ( of next and previous range)

Viewing 5 posts - 16 through 19 (of 19 total)

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

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

Thanks, Ben. I appreciate the very kind feedback.

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

rajemessage 14195 Hall of Fame Points: 3315 More actions · Answer 2

rajemessage 14195

Hall of Fame

Points: 3315

May 28, 2016 at 5:26 am

#1881913

pls answer

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 3

rajemessage 14195 (5/28/2016)
pls answer

well this thread is now over three months old......and looking back thro it, you have been given various suggestions.....do any of them work for you?,

If not then please post what results you are expecting from the sample data you provided. (which has already been asked for several times!)

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 4

possible guess on what you expect...........is this right or wrong?

+---------------------+

¦ pointfrom ¦ pointto ¦

¦-----------+---------¦

¦ 1 ¦ 6 ¦

¦-----------+---------¦

¦ 7 ¦ 9 ¦

¦-----------+---------¦

¦ 10 ¦ 12 ¦

+---------------------+

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 5

rajemessage 14195 (5/28/2016)
pls answer

We gave you several shots in the dark. If those answers don't work, how about telling us what was wrong and what it is you expected. We can't read your mind.