agreed,

but situation is such. we want to take this challenge , and I have posted that solution at the top, it works in all conditions, the only thing I wanted...

no it does not, if @BeginStation is greater than @EndStation.

if  b =0   and e =10 and  @BeginStation = 18 and  @EndStation = 8

then it will no fall in first block...

• This reply was modified 4 years, 10 months ago by  rajemessage 14195.

the situation at my end is that begin can be less than equal to or greater than equal to. and by logic works for it , only thing is, it...

-- in following "#t" table one can enter b as 10 and e as 2 that means e can be smaller than b and b can be smaller than e

--...

thank u , i am working on it.

-- b and c col can get reversed range like insted of 2 to 5 one can enter 5 to 2 , so...

• This reply was modified 4 years, 10 months ago by  rajemessage 14195.
• This reply was modified 4 years, 10 months ago by  rajemessage 14195.
• This reply was modified 4 years, 10 months ago by  rajemessage 14195.

1) two tables store range data related to two different activities, but for simplicity, I have removed other cols.

2) any range could be entered as long as decimal(13,4) supports.

3) I...

• This reply was modified 4 years, 10 months ago by  rajemessage 14195.
• This reply was modified 4 years, 10 months ago by  rajemessage 14195.

sorry it was 100 to 200

create table t ( b decimal(13,4) not null, c decimal(13,4) not null);

Insert into T (B,C) values ( 1,200);

Insert into T (B,C) values (   200   ,400);

Insert...

• This reply was modified 4 years, 10 months ago by  rajemessage 14195.
• This reply was modified 4 years, 10 months ago by  rajemessage 14195.

i think my version is fast , so should i use my version. or is there any thing wrong , so that i use yours.

my question is ,

is my version is correct or is there any harm in it?

secondly removing loop with set base is good?

third is there any way to write, my version,...