속도는 느리지만, 가끔 필요한 소스이다.
다른 방법이 있으면 알려주세요!!
CASE @TestVal
WHEN 1 THEN CASE @TestVal2
WHEN 1 THEN 'First'
ELSE @TestVal2
WHEN 2 THEN 'Second'
WHEN 3 THEN 'Third'
ELSE 'Other'
END
일을 하다보니, 가끔 내부적으로 특정 데이터만 다시 뽑길 원해서 사용한다..ㅠㅠ
야매인듯..
CASE expressions can be used in SQL anywhere an expression can be used. Example of where CASE expressions can be used include in the SELECT list, WHERE clauses, HAVING clauses, IN lists, DELETE and UPDATE statements, and inside of built-in functions.
Two basic formulations for CASE expression
1) Simple CASE expressions
A simple CASE expression checks one expression against multiple values.
Within a SELECT statement, a simple CASE expression allows only an
equality check; no other comparisons are made. A simple CASE expression
operates by comparing the first expression to the expression in each
WHEN clause for equivalency. If these expressions are equivalent, the
expression in the THEN clause will be returned.
Syntax:
CASE expression
WHEN expression1 THEN expression1
[[WHEN expression2 THEN expression2] [...]]
[ELSE expressionN]
END
Example:
DECLARE @TestVal INT
SET @TestVal = 3
SELECT
CASE @TestVal
WHEN 1 THEN 'First'
WHEN 2 THEN 'Second'
WHEN 3 THEN 'Third'
ELSE 'Other'
END
2) Searched CASE expressions
A searched CASE expression allows comparison operators, and the use of
AND and/or OR between each Boolean expression. The simple CASE
expression checks only for equivalent values and can not contain Boolean
expressions. The basic syntax for a searched CASE expressions is shown
below:
Syntax:
CASE
WHEN Boolean_expression1 THEN expression1
[[WHEN Boolean_expression2 THEN expression2] [...]]
[ELSE expressionN]
END
Example:
DECLARE @TestVal INT
SET @TestVal = 5
SELECT
CASE
WHEN @TestVal <=3 THEN 'Top 3'
ELSE 'Other'
END
Reference : Pinal Dave (http://blog.SQLAuthority.com)
