how to find gap in a range.

rky

I use sql 2012 but, one can answer up to 2019

 

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 into T (B,C) values (  600,   900);

create table t1 (b decimal(13,4) not null, c decimal(13,4) not null);
Insert into t1 (B,C) values ( 1,100);
Insert into t1 (B,C) values (  200   ,500);
Insert into t1 (B,C) values (  800,   1000);

-- "t" and "t1" table holds ranges which could be any thing where b<c, i have to find out where "t" has range but "t1" does not?
--ex "t"  has 1,200 , "t1"  1,100  so i want to see 100 to 200 t2 does not have any thing.

Q) i have to find out the range where "t" has got range but "t1" does not? that means start range and end range will be passed

and i have to find out the range where "t1" is not done but "t" is done

-- case 1 table "t" and "t1" will have no overlap  with in the table

-- case 2 they will have overlap with in the table.

 result 

100 -200

600 - 800

yours sincerley

DerFredo

Off the top of my head, that sounds like a variation of the "gaps and islands" problem. In T-SQL you can use window functions (or other ways) to solve the basic problem, maybe you can extend that approach. Look here, for example: https://www.red-gate.com/simple-talk/sql/t-sql-programming/the-sql-of-gaps-and-islands-in-sequences/

johnwilliam23

You need to identify any ranges not included between 0 and 1. Note that some ranges do overlap. The exclusivity of the endpoints is not relevant for use case; You only need to identify what the endpoints of the gaps.

Here is the table structure:

DECLARE @ CheckRegister TABLE

(

   AccountNumber Varchar(10),

   CheckNumber Varchar(10)

)

John,
Essay Writer

BrandonCooper

Anyone who at least once wrote an essay and term paper himself knows how hard it is to cope with this task. That's why we've created a really working guide https://papernow.org/college-papers for you to help you with this task.

Collins

We will help you, wherever you study, at the university or in college. Certified specialists will perform work of any difficulty and of any volume https://grademiners.com/ the main thing is to ask about it, so do not waste your chance and use their services, they are waiting for you!

evelynhermann

I am an essay writer and currently working with an online essay writing service Essaywriting. Your all kind of write my essay requests will entertain here fast by expert writers.
https://essayswriting.org/

Chante89

Hello everybody! I recently started developing my business and discovered a service that helps to hire a qualified team for any development, and you can find more here, because the world changes have made it big in the market over the past few years. There is a need for mobile applications in the market, and therefore more and more companies are taking advantage of the platform. Good luck!

myessaywriter

This is really a good source of information, I will often follow it to know more information and expand my knowledge, I think everyone should know it, thanks

Visit Here :- Essay writer bot

PippaChapman

Thx you john for your answer!!

TonyMerrow

This is really a good source of information, I will often follow it to know more information and expand my knowledge, I think everyone should know it, thanks
https://www.forextime.com/trading-accounts/demo-account

Jeff Moden

Lordy... the spammers sure had a field day on this one.   

DerFredo cited a really good link by Dwain Camps on the subject.  Other than my posts, it's also the only post that has nothing to do with the spam that the others have written.  I'm not even going to mention the subject of the spam the others have written for fear of the damned bots and human moroffs posting more spam.

Edgarpo

Hi to all !!!