title: Distribute input value to table columns based on another column in SQL
body: <p>Here's the dilemma that I have:
  Declare @dis_qty = 20; --input</p>
  <p>the table has values:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">id</th>
  <th style="text-align: center;">sk_code</th>
  <th style="text-align: center;">o_qty</th>
  <th style="text-align: center;">pick_qty</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">1</td>
  <td style="text-align: center;">sk_123</td>
  <td style="text-align: center;">10</td>
  <td style="text-align: center;">null</td>
  </tr>
  <tr>
  <td style="text-align: left;">2</td>
  <td style="text-align: center;">sk_123</td>
  <td style="text-align: center;">5</td>
  <td style="text-align: center;">null</td>
  </tr>
  <tr>
  <td style="text-align: left;">3</td>
  <td style="text-align: center;">sk_123</td>
  <td style="text-align: center;">17</td>
  <td style="text-align: center;">null</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Needed update query with below result</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">id</th>
  <th style="text-align: center;">sk_code</th>
  <th style="text-align: center;">o_qty</th>
  <th style="text-align: center;">pick_qty</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">1</td>
  <td style="text-align: center;">sk_123</td>
  <td style="text-align: center;">10</td>
  <td style="text-align: center;">10</td>
  </tr>
  <tr>
  <td style="text-align: left;">2</td>
  <td style="text-align: center;">sk_123</td>
  <td style="text-align: center;">5</td>
  <td style="text-align: center;">5</td>
  </tr>
  <tr>
  <td style="text-align: left;">3</td>
  <td style="text-align: center;">sk_123</td>
  <td style="text-align: center;">17</td>
  <td style="text-align: center;">5</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>pick_qty column should be assign based on input value i.e, @dis_qty.</p>
  <p>note: without using loops</p>