title: SQL Server : Arithmetic overflow error converting expression to data type int
body: <p>I'm getting this error </p>
  
  <blockquote>
    <p>msg 8115, level 16, state 2, line 18<br>
    Arithmetic overflow error converting expression to data type int.</p>
  </blockquote>
  
  <p>with this SQL query</p>
  
  <pre><code>DECLARE @year VARCHAR(4);                       
  DECLARE @month VARCHAR(2);                      
  
  -- START OF CONFIGURATION SECTION                       
  -- THIS IS THE ONLY SECTION THAT SHOULD BE MODIFIED                     
  -- SET THE YEAR AND MONTH PARAMETERS                        
  
  SET @year = '2013';                     
  SET @month = '3';  -- 1 = January.... 12 = Decemeber.                       
  
  -- END OF CONFIGURATION SECTION                     
  
  DECLARE @startDate DATE                     
  DECLARE @endDate DATE                       
  SET @startDate = @year + '-' + @month + '-01 00:00:00';                     
  SET @endDate = DATEADD(MONTH, 1, @startDate);                       
  
  SELECT                          
      DATEPART(YEAR, dateTimeStamp) AS [Year]                         
      , DATEPART(MONTH, dateTimeStamp) AS [Month]                         
      , COUNT(*) AS NumStreams                        
      , [platform] AS [Platform]                      
      , deliverableName AS [Deliverable Name]                     
      , SUM(billableDuration) AS NumSecondsDelivered                      
  FROM                            
      DeliveryTransactions                        
  WHERE                           
      dateTimeStamp &gt;= @startDate                     
  AND dateTimeStamp &lt; @endDate                        
  GROUP BY                            
      DATEPART(YEAR, dateTimeStamp)                       
      , DATEPART(MONTH, dateTimeStamp)                        
      , [platform]                        
      , deliverableName                       
  ORDER BY                            
      [platform]                      
      , DATEPART(YEAR, dateTimeStamp)                         
      , DATEPART(MONTH, dateTimeStamp)                        
      , deliverableName   
  </code></pre>