build relationship between columns

Question

Viewing 3 posts - 1 through 2 (of 2 total)

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

Vijaya Kadiyala SSCrazy Eights Points: 9119 More actions · Answer 1

Hi,

what kind of relationship you have in between A & B?

Thanks -- Vj

Thanks -- Vijaya Kadiyala
www.dotnetvj.com
SQL Server Articles For Beginers

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 2

Are you looking for an Islands and Gaps solution?

This is from Itzik Ben-Gan's Inside TSQL Querying and identifies missing values

SELECT cur+1 AS start_range, nxt-1 AS end_range

FROM (SELECT col1 AS cur,

(SELECT MIN(col1) FROM dbo.T1 AS B

WHERE B.col1 > a.col1) AS nxt

FROM dbo.T1 AS A) AS D

WHERE nxt-cur > 1;

You'd have to find a way to run this for both sets of numbers to identify the missing values. Logically a bit of a twister, but a very simple query.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt