title: Create a table on specific filegroup in SQL Server?
body: <p>So, this process I have is actually on SAS but the SQL syntax should be the same I need to put it on the filegroup STAGING_DATA_FG02, so I added as you can see below a line of code I thought would help but it is not reading it, is it the correct syntax?</p>
  <pre class="lang-sql prettyprint-override"><code>CREATE TABLE DBO.TBL
  AS
  SELECT 
    input(&amp;varFileDate, BEST22.) as FileDate  ,
    TRIM(SSN) as SSN              , 
    ExmDescription                , 
    Status                        ,
    ScaledScore                   ,
    ExamDate          
    FROM DBO.TBL_A
    ORDER BY SSN
    ON [STAGING_DATA_FG02] WITH (DATA_COMPRESSION = PAGE);
  </code></pre>