Sql server 2008 r2: case statement in where clause for current fiscal year?

Your CASE statement should always be: CASE WHEN (condition) THEN (return value) WHEN (condition 2) THEN (return value 2) ... 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.

Your CASE statement should always be: CASE WHEN (condition) THEN (return value) WHEN (condition 2) THEN (return value 2) ... 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.....

I figured it out: WHERE ( (datepart(yy, dateadd(second,open_date,'19700101')) = datepart(yy, GetDate()) AND datepart(mm, dateadd(second,open_date,'19700101')) > 6 AND datepart(mm, GetDate()) > 6) OR (datepart(yy, dateadd(second,open_date,'19700101')) = datepart(yy, GetDate()) AND datepart(mm, dateadd(second,open_date,'19700101')) 6 AND datepart(mm, GetDate()).

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.