title: Converting Access SQL Queries to SqlServer
body: <p>I've been given the task of converting DOZENS of access tables, queries, macros, and reports to SQL Server and well its going horrible so far.</p>
  
  <p>Like this for instance:</p>
  
  <pre><code>SELECT [Numbers by Quarter and Bedsize].SizeCategory, 
  [Numbers by Quarter and Bedsize].Bedsize, 
  [Numbers by Quarter and Bedsize].[SumOfNumber of CLABSI], 
  [Numbers by Quarter and Bedsize].[SumOfCentral Line Days],
   Round(1000*[Numbers by Quarter and Bedsize].[SumOfNumber of CLABSI]/[Numbers by Quarter and Bedsize].[SumOfCentral Line Days],2) AS [State CLABSI Rate], 
   [Numbers by Quarter and Bedsize].SummaryYQ
  FROM [Numbers by Quarter and Bedsize]
  ORDER BY [Numbers by Quarter and Bedsize].SizeCategory, [Numbers by Quarter and Bedsize].SummaryYQ;
  </code></pre>
  
  <p>While I've seen SQL code before (mostly mysql) I've never seen anything like <code>[Numbers by Quarter and Bedsize].SizeCategory</code></p>
  
  <p>Are there any good tutorials to convert Access SQL to SQLServer? Please note, that I haven't actually touch either Access or SqlServer before in my life.</p>