Query for history table

• reddysrinu

  SSC Veteran

  Points: 245

  More actions

  November 3, 2015 at 5:45 pm

  #321896

  I have order history table that tracks who worked on a order

  ID. ColA. ColB. ColC

  1. Process 1234

  2. Work. 7666

  3. Return. 6789

  4. Work. Null Role1

  5. Return. 6538

  I want a query to return recent colB or ColC where colA or colB are not null. In this case row 4

  I have order history table that tracks who worked on a order

  Another example

  ID. ColA. ColB. ColC

  1. Work. 1234

  2. Process. 7666

  3. Return. 6789

  I want a query to return most recent colB or ColC where colB or ColC are not null. In this case row 2

  Can you please help

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  November 4, 2015 at 2:05 am

  #1837544

  I can't make heads nor tails of your sample data.

  Can you please take a look at the link in my signature on posting code and data for the best help, so that we can understand your data and problem.