Table Variables And Calculations

 
So, I've got a problem with using table variable "fields" and a simple variable in calculations. It ain't workin'. See the bolded code below. When I run the SP, it returns 0 for those values. Anyone got any clues? Is this a table variable limitation?


 ALTER PROCEDURE YearlyTotalsInPercentages(@Year int) AS

BEGIN

DECLARE @TotalSum int
DECLARE @Totals TABLE
(
CBDCYearlyTotals int,
ProductLine varchar(50)
)

INSERT INTO @Totals (CBDCYearlyTotals, ProductLine)
SELECT SUM(dbo.Main.Hours), dbo.Project.ProductLine
FROM dbo.Main
INNER JOIN dbo.Department ON dbo.Main.DeptNo = dbo.Department.DeptNo
INNER JOIN dbo.Project ON dbo.Main.ProjectNo = dbo.Project.ProjectNo
WHERE dbo.Main.UserID LIKE 'CI%'
AND dbo.Project.ControlLocation = 'IND'
AND DATEPART(yyyy, dbo.Main.DataDate) = @Year
AND dbo.Main.Active = 1
GROUP BY dbo.Project.ProductLine

SET @TotalSum = (SELECT SUM(dbo.Main.Hours)
FROM dbo.Main
INNER JOIN dbo.Department ON dbo.Main.DeptNo = dbo.Department.DeptNo
INNER JOIN dbo.Project ON dbo.Main.ProjectNo = dbo.Project.ProjectNo
WHERE dbo.Main.UserID LIKE 'CI%'
AND dbo.Project.ControlLocation = 'IND'
AND DATEPART(yyyy, dbo.Main.DataDate) = @Year
AND dbo.Main.Active = 1)


SELECT t.CBDCYearlyTotals AS CBDCYearlyTotals, t.ProductLine AS ProductLine, @TotalSum AS TotalSum, ROUND((t.CBDCYearlyTotals/@TotalSum) * 100, 1) AS Percentage FROM @Totals t

END
GO
 

 Thanks Yall