combine second column to rows above

• RCoston

  Mr or Mrs. 500

  Points: 585

  More actions

  February 26, 2006 at 9:10 pm

  #111976

  Hi I have the following table:

  col1   |   col2

  abc        null

  def         null

  null         123

  null         456

  I want to have: {result set}

  col1   |   col2

  abc        123

  def         456

  Without cursors and in a single SQL statement.

  Thanks

• Sergiy

  SSC Guru

  Points: 110192

  More actions

  February 26, 2006 at 9:16 pm

  #623389

  What must stop from returning such set:

  col1   |   col2

  abc        456

  def         123

  _____________
  Code for TallyGenerator