Versions Compared

Key

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

...

View file
namescriptActivateV2.sql
height250
View file
nameupdateKindToSecutixWba.sql
height250

Code Block
languagesql
titleFourth step: General update
update card_type set active='F' where  cardtype_id in (select cardtype_id from card_type ct2 where ct2.code != 'Fortress' and ct2.instit_code = :instit_code) and instit_code = :instit_code;