Reg - Log table data

• vinodhkumargv

  SSC Enthusiast

  Points: 147

  More actions

  February 17, 2014 at 6:47 am

  #304433

  Hi Friends ,

  I have two table like log table and main table as below

  LOG TABLE

  IDPREVSTATUSCURR STATUS

  1NULLOpen

  1OpenPending

  1PendingOpen

  1OpenOpenRequest

  1OpenRequestClosed

  MAIN TABLE

  IDPREVSTATUSCURR STATUSMATCHID

  1OpenOpenNULL

  1OpenOpen100

  1PendingPending101

  1OpenOpen102

  1OpenOpenRequest103

  1ClosedClosed104

  1ClosedClosed104

  1ClosedClosed106

  and i want the result like

  RESULTIDMATCHID

  1NULL

  1101

  1102

  1103

  1104

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  February 17, 2014 at 6:58 am

  #1689490

  Duplicate. No replies to this please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1542092-391-1.aspx

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass