help me Sql Experts Come Here

[andhrabullet]

Table lo two columns values ila ulna.. col 1 and col2.. vati values 

 

hyd - bom

bom- chen

Chenn- Delhi

 

 

unte ...delete chesi hyd- Delhi insert cheyyali coz of relationship

 

inko Case

 

hyd - bom

bom- chen

Chenn- Delhi

Delhi-Hyd

 

then all records delte cheyyali..since hyd- hyd undi

 

PS: order of values may not in sequence.. we have to identify relation ship..based on travel date 

[dappusubhani]

A -> B enti asalu? 

 

2 columns unnai, okay. then....

[andhrabullet]

Columns lo values avi

[tables]

kochen lo clarity ledu. koncham detail ga veyi.

[150bryant]

logic...

 

case 1-- if you find col1.A in col2...

then insert A-A

 

case2-- if you didnt find col1.A in col2, then populate A with D ( highest value)

[JollyBoy]

recursive cte use cheyali pardhu 

[150bryant]

logical question

 

hyd - bom

bom- chen

Chenn- Delhi

 

hyd delhi endhuku insert cheyali ? there must be a reason kadha

like --it is the latest..

or it is the last update

or it has a max effective date..

etc ?

[ronitreddy]

 

logical question

 

hyd - bom

bom- chen

Chenn- Delhi

 

hyd delhi endhuku insert cheyali ? there must be a reason kadha

like --it is the latest..

or it is the last update

or it has a max effective date..

etc ?

 

because multiple segments unnayi hyd to Delhi ki velle process lo..

 

Reports lo Origin, Destination anthe chudali ankunta..Ala data populate avvali ankunta ..

[150bryant]

because multiple segments unnayi hyd to Delhi ki velle process lo..

 

Reports lo Origin, Destination anthe chudali ankunta..Ala data populate avvali ankunta ..

manam ankodam kadhu..TS edi ankuntey adhey implement cheyali

[ronitreddy]

manam ankodam kadhu..TS edi ankuntey adhey implement cheyali

Anduke nen ankunta ani cheppina bro..TS ochi confirm chesthe better

[dappusubhani]

manam ankodam kadhu..TS edi ankuntey adhey implement cheyali