SQL Case Statement, Alias values with 2 conditions

Question

Trying to do a case statement with 2 values. I tried following SQL Case with 2 conditions example but unable to get it.

Logic trying to do: where stack is in nodeName and overflow is in scenarioName, then replace nodeName value Stack with Usethisvalue, within the nodeName column.

My query:

SELECT endOfDay as businessDate,
(CASE nodeName,
WHEN nodeName = 'Stack' AND scenarioName = 'Overflow' THEN Usethisvalue
END) as nodeName,
scenarioName, Value
FROM CONTRIBUTION

Can anyone help with this?

Zaynul Abadin Tuhin · Accepted Answer · 2019-10-23T16:49:23.083

3

try like below

SELECT endOfDay as businessDate,
CASE WHEN nodeName = 'Stack' AND scenarioName = 'Overflow' THEN 'Usethisvalue'
else nodeName END as nodeName,
scenarioName, Value
FROM CONTRIBUTION

edited Oct 23 '19 at 16:49

answered Oct 23 '19 at 16:38

Zaynul Abadin Tuhin

31,407
5
33
63

`invalid column name 'UsethisValue'` – excelguy Oct 23 '19 at 16:48
@excelguy check now – Zaynul Abadin Tuhin Oct 23 '19 at 16:49

score 0 · Answer 2 · answered Oct 23 '19 at 16:42

0

SELECT
endOfDay as businessDate, nodeName, WHEN nodeName = 'Stack' AND scenarioName = 'Overflow' THEN Usethisvalue ELSE nodeName END as nodeName, scenarioName, Value FROM CONTRIBUTION

answered Oct 23 '19 at 16:42

AlexARH

212
1
6

SQL Case Statement, Alias values with 2 conditions

2 Answers2