xml solution and function solution ex, calling scalar funtion i had . apart from these if any thing is there then pls tell me so that i stop finding and...

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

we tried to upgrade to 2019, but unfortunately, MS has put some restrictions like they have converted scalar functions to inline function by default and that throws an error, so...

in the 2 solution: pass means, in with cte, first, it goes to a temp table then it is read again which is second pass and then where clause is...

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

both are working, the only thing is first they multiply by using cross apply, that takes one pass, then where clause is applied to fillter, that makes the second pass.

in...

ya, I have checked, I will update with an example why they do not fit into.

primarily they do not give result in one go,

first they find the small and big...

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 5 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 5 years, 11 months ago by rajemessage 14195.
• This reply was modified 5 years, 11 months ago by rajemessage 14195.
• This reply was modified 5 years, 11 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 5 years, 11 months ago by rajemessage 14195.
• This reply was modified 5 years, 11 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 5 years, 11 months ago by rajemessage 14195.
• This reply was modified 5 years, 11 months ago by rajemessage 14195.