Posted by Kart on 10/18/06 20:07

select 'Color' = CASE
WHEN Sum(ActualSales - ForecastSales) > 0 THEN 'Green'
Else 'Red'
END
from <TableName>

Pradeep wrote:
> Hello,
>
> 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.
>
> Thank you in advance for your help.
>
> Pradeep

• Next in forum: [Announce] Stylus Studio 2007 Reviewed by CRN Magazine
• Prev in forum: Re: SQL Server 2005 - SELECT query
• Thread view: Re: SQL statement to compare and return one aggregated value

[Reply to this message]