Version flag

• am-244616

  SSCarpal Tunnel

  Points: 4936

  More actions

  April 29, 2008 at 4:32 pm

  #189958

  Guys,

  I have following scenario where I need to populate version flag based on the partyid, count and seq columns.

  Here is it how it should populate for each new count of a partyid the max(seq) should be versioned as 1

  For example

  PARTYCOUNT SEQ VERSION

  _________________________________________________

  10011 1

  10111 0

  10112 1

  10121 0

  10122 0

  10123 1

  10231 1

  Is there any way to populate this version flag.

  Any sugggestions and inputs would help

  Thanks

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736255

  More actions

  April 29, 2008 at 6:18 pm

  #808723

  you need to devise an algorithm that determines the version flag based on the inputs.

  This sounds like homework. If you show an attempt and explain what you want to do in the update, we can help you get it done.