I have 2 Declared expressions that I need to add together, I know how to do a normal SUM on Select statements however this is a little different, or at least it appears that way to me.
Here are the 2 Declared Statements:
declare @Amount float
select top 1 @Amount = CAST(dbo.Designated_Amount.Amount AS Float)
FROM dbo.Designated_Amount INNER JOIN
dbo.SIMS ON dbo.Designated_Amount.Unit_Code = dbo.SIMS.Unit_Code
WHERE not exists (Select * From dbo.SIMS Where (dbo.Designated_Amount.Unit_Code = '114') AND dbo.SIMS.Event_Type in ('IR','ME',
View Complete Post