Complex Query--- needs a solution

• hemanth T

  SSC Eights!

  Points: 807

  More actions

  June 28, 2011 at 2:25 am

  #252594

  Hello Everybody,

  I got a situation that i need to get details,process 3 times based on conditions and i need to get consolidated output.

  My scenario almost looks like this :

  input

  v

  1

  v

  2 3

  v

  4 5

  v

  6 7

  i need 2,4,6,7 as output

  what logic can i follow for this and can i use cte,case,..etc.,

  Can anyone try to solve this

  Thanks in advance....................

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  June 28, 2011 at 3:49 am

  #1345035

  Your requirement is bait confusing.

  Can you post table script, sample data and expected output?

  If in doubt, you can check out the article linked in my signature line.

  -- Gianluca Sartori