Viewing 15 posts - 61 through 75 (of 142 total)
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...
January 31, 2020 at 11:55 am
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...
January 31, 2020 at 5:07 am
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...
January 30, 2020 at 12:53 pm
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...
January 30, 2020 at 11:34 am
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...
January 30, 2020 at 9:41 am
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...
January 29, 2020 at 11:55 am
-- 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
--...
January 22, 2020 at 10:35 am
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...
January 15, 2020 at 11:44 am
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...
January 13, 2020 at 5:22 am
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...
January 12, 2020 at 7:08 am
July 6, 2017 at 7:52 am
July 6, 2017 at 6:13 am
March 13, 2017 at 8:57 am
March 12, 2017 at 5:37 am
February 22, 2017 at 6:47 am
Viewing 15 posts - 61 through 75 (of 142 total)