title: Getting two counts and then dividing them
body: <p>I am attempting to get two counts and then divide those two counts to get the ratio of the items I am counting. I saw this post <a href="https://stackoverflow.com/questions/9222664/getting-a-count-of-two-different-sets-of-rows-in-a-table-and-then-dividing-them">here</a> and tried that. I am getting an error in my results, no error message just incorrect number. I am using SQL-Server 2008</p>
  
  <p>Here is my code:</p>
  
  <pre><code>-- INTERNAL PEPPER REPORT
  --#####################################################################
  
  -- VARIABLE DECLARATION AND INITIALIZATION
  DECLARE @SD DATETIME
  DECLARE @ED DATETIME
  
  SET @SD = '2013-01-01'
  SET @ED = '2013-03-31'
  
  -- TABLE DECLARATION ##################################################
  DECLARE @TABLE1 TABLE(NUMERATOR INT, DENOMINATOR INT, RATIO INT)
  --#####################################################################
  
  -- WHAT GETS INSERTED INTO TABLE 1
  INSERT INTO @TABLE1
  SELECT
  A.NUM, A.DENOM, A.NUM/A.DENOM 
  
  FROM
  (
  -- COLUMN SELECTION. TWO NUMBERS WILL REPRESENT A NUM AND A DENOM
  SELECT 
      (SELECT COUNT(DRG_NO)
          FROM smsdss.BMH_PLM_PtAcct_V
          WHERE drg_no IN (061,062,063,064,065,066)
          AND Adm_Date BETWEEN @SD AND @ED
          AND PLM_PT_ACCT_TYPE = 'I')
          AS NUM,
      (SELECT COUNT(DRG_NO)
          FROM smsdss.BMH_PLM_PtAcct_V
          WHERE drg_no IN (061,062,063,064,065,066,067,068,069)
          AND Adm_Date BETWEEN @SD AND @ED
          AND Plm_Pt_Acct_Type = 'I')
          AS DENOM
  )A
  
  SELECT NUMERATOR, DENOMINATOR, RATIO
  FROM @TABLE1
  </code></pre>
  
  <p>The counts get produced and displayed correctly, but for a ratio I get 0 and am not sure as to why I get this.</p>
  
  <p>Thank You,</p>