title: Update two columns with list of data in sql server SP
body: <p>i have one table that have Ads_Id And Priority in sql server </p>
  
  <p>it possible the create procedure for update Ads_Id And Priority with a list ?</p>
  
  <p>for example in a single query </p>
  
  <pre><code>update AdsPriority set [Priority] = 3 where Ads_Id = 1
  </code></pre>
  
  <p>change to </p>
  
  <pre><code>update AdsPriority set [Priority] = (List Of Id) where Ads_Id = (List of Priority) 
  </code></pre>
  
  <p>thank you for your help</p>