title: Set more than one variable value in case statement in sql
body: <pre><code>declare @Month int
  declare @A int
  Declare @B int
  Set @Month = 1
  
  SELECT  
  CASE   
  WHEN @Month=1 THEN @A=11,@B=21
  WHEN @Month=2  THEN @A=111,@B=211
  ELSE @A=11,@B=13  END 
  </code></pre>
  
  <p>I want to set multiple variable base on condition in <code>SQL</code>.
  How to do that.I am getting error when I doing like this.</p>