Sum 2 variables in a stored procedure, how ?

[Webkins]

I am having troubles to sum these 2 variables into one. I have tried many combinations of the code below but nothing seems to work...

--Query for data
SET @raw_gallons = (SELECT raw_gallons FROM impregnation.dbo.tank_raw)
SET @day_gallons = (SELECT day_gallons FROM impregnation.dbo.tank_day)

SET @Combined_Levels = (select SUM(@raw_gallons + @day_gallons))
SET @Combined_Levels = SUM(@raw_gallons + @day_gallons)
SET @Combined_Levels = (@raw_gallons + @day_gallons)

Thanks to all for your suggestions and help.

 

[Qik3Coder]

That's not going to work the way you think it is, unless by some freaky chance you only have 1 row in each of those tables, though it will probably still give you ayntax error)

You probably want something like:

Select tr.raw_gallons + td.day_gallons
FROM tank_raw tr
LEFT JOIN tank_day td ON
   tr.tankID = td.tankID
Order by tankID

Lodlaiden

You've got questions and source code. We want both!
Oh? That? That's not an important password. - IT Security Admin (pw on whiteboard)