Need to do nested Case statements in SQL? Use the following syntax. This should result in ‘a1b1 – yar’
DECLARE @a INT DECLARE @b INT SET @a = 1 SET @b = 2 SELECT CASE WHEN @a = 1 THEN CASE WHEN @b = 1 THEN 'a1b1' WHEN @b = 2 THEN 'a1b2 - yar' END --Ends the inner case WHEN @a = 2 THEN CASE WHEN @b = 1 THEN 'a2b1' WHEN @b = 2 THEN 'a2b2' END --Ends the inner case END --Ends the outer case
This took me a little time to work out the syntax, but pretty simple once I understood case statements a little better.
For some more info on case statements, you can go to the msdn article located at http://msdn.microsoft.com/en-us/library/ms181765.aspx