title: How to edit this Access SQL code
body: <p>I am the newbie in this filed so I would appreciate it if you could help me. I have this SQL code in my Access and now I need the same in Microsoft SQL server management studio. So I need to edit something but don't know what and how.</p>
  
  <pre><code>SELECT Server.Outlook, Server.Region, 
    Server.Country, Server.Territory, Server.Branch, 
    Server.Tier, Server.Division, Server.Type, 
    Server.Year, Server.sMonth, 
    IIf([Data]="Extra Trips",[Qty],0) AS [Extra Trips], 
    IIf([Data]="Hours",[Qty],0) AS Hours, 
    IIf([Data]="Predict",[Qty],0) AS Predict, 
    IIf([Data]="Reduc",[Qty],0) AS Reduc, 
    IIf([Data]="Rev",[Qty],0) AS Rev, 
    IIf([Data]="Service Req",[Qty],0) AS [Service Req],    
    IIf([Data]="TCUP",[Qty],0) AS TCUP, 
    IIf([Data]="Total Kills",[Qty],0) AS [Total Kills], 
    IIf([Data]="Work Ord",[Qty],0) AS [Work Ord], 
    IIf([Data]="FTE",[Qty],0) AS FTE 
  INTO Server_FINAL
  FROM Server;
  </code></pre>