Posted by Ed Murphy on 10/18/06 02:29

Pradeep wrote:

> In my table, I have two columns - ForecastSales and ActualSales. I need
> to write a query that returns me just one aggregate value (one row and
> one column). If sum(ActualSales - ForecastSales) is negative, I need to
> return "red." Otherwise, I need to return green.
>
> I looked at CASE statement. However, I could not figure out an
> efficient way to build this query. I would appreciate your help.

declare @TheValue decimal(15,2)
declare @TheResult varchar(5)

select @TheValue = (
select sum(ActualSales - ForecastSales)
from TheTable
)

select @TheResult = case
when @TheValue < 0 then 'red'
else 'green'
end

• Next in forum: Re: What is the best way to store a shopping list or order?
• Prev in forum: Re: How can I create a cool data model table map?
• Thread view: Re: SQL statement to compare and return one aggregated value

[Reply to this message]