title: Can I put two update statements for the same table in a condition?
body: <p>I have two update statement blocks. Both for the same table with different 'where' part. I want that if one update runs, the other shouldn't. </p>
  
  <p>Here's my code for the update statements:</p>
  
  <pre><code>Update transactionalData.TBL_WORK_ORDER_BOOKING_DETAILS  
   set Status='COMPLETED',EndDate= @date,Hours= convert (float,datediff(ss,StartDate,  @date ))/3600  
    where SignumID=@signumID and BookingID=@BookingID and status='started'  
  
  Update transactionalData.TBL_WORK_ORDER_BOOKING_DETAILS
      set Status='Inprogress' where SignumID=@signumID and Status='onhold'  and BookingID=@BookingID
  END 
  </code></pre>