Case with where clause in sql server 2008 - Expected Income 270 euro

Analysis of the search query	case with where clause in sql server 2008
Competition	Low
The average cost per click Adsense	0.96 €
The expected traffic per day	9
The expected traffic per month	270
Income per month	270 €

Top competitors on query "case with where clause in sql server 2008"

CASE (Transact-SQL)
  http://technet.microsoft.com/en-us/library/ms181765.aspx  Competition: low
Using CASE in an UPDATE statement The following example uses the CASE expression in an UPDATE statement to determine the value that is set for the column VacationHours for employees with SalariedFlag set to 0. Using a SELECT statement with a simple CASE expression Within a SELECT statement, a simple CASE expression allows for only an equality check; no other comparisons are made

SQL Server Forums - help with query (count with case statement)
  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=99913  Competition: low
What you posted is exactly what I wanted, but I'm having difficulty putting it in the query below, which isn't what I originally posted.Here below is the full query

sql server 2008 r2: case statement in where clause for current fiscal year - Stack Overflow
  http://stackoverflow.com/questions/7933295/sql-server-2008-r2-case-statement-in-where-clause-for-current-fiscal-year  Competition: low
ELSE (return value x) END Those two lines really don't fit in there - after the WHEN keyword, you should have just a simple expression that returns a single value - not two lines of code....