title: Set flag to database column
body: <p>The task is creating sql script which set flag "Y" or "N" to existed dummy database line "Status" if integer value more or less '10'</p>
  
  <p>database consists of three columns
  person
  money (5 or 100)
  status (dummy - should be updated via stored procedure)</p>
  
  <p>Solution is </p>
  
  <pre><code>update status set flag = "Y" where money = '5' and 
  status set flag = "N" where money = '100'
  </code></pre>
  
  <p>Novice in SQL scripting</p>