msg 8115,level 16,state 2,line 18
Arithmetic overflow error converting expression to data type int.

@H_404_6@

用这个SQL查询

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 >= @startDate                     
AND dateTimeStamp < @endDate                        
GROUP BY                            
    DATEPART(YEAR,dateTimeStamp),[platform],deliverableName                       
ORDER BY                            
    [platform],DATEPART(YEAR,deliverableName