Versions Compared

Version Old Version 5 New Version 6
Changes made by

Chris Smith

Chris Smith

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
themeEclipse
title1. View versions and statuses for selected award
select award_number, sequence_number, award_id, award_sequence_status from award where award_number='100000-00001' order by sequence_number;
Code Block
languagesql
themeEclipse
title2. If no ACTIVE version, set the PENDING version to ACTIVE
update award set award_sequence_status='ACTIVE' where award_sequence_status='PENDING' and award_id='111111';