Im trying to create a string in a select statement that returns which columns are in error e.g
SELECT Col1, Col2, Col3,
CASE WHEN Col1 = 0 THEN 'Col1 Is In Error' END +
CASE WHEN Col1 = 0 THEN 'Col1 Is In Error' END +
CASE WHEN Col1 = 0 THEN 'Col1 Is In Error' END AS Result
FROM Table1
It doesnt work, so wondering what else I can try.
Life is a blast when you have a semi-automatic..
SELECT Col1, Col2, Col3,
CASE WHEN Col1 = 0 THEN 'Col1 Is In Error' END +
CASE WHEN Col1 = 0 THEN 'Col1 Is In Error' END +
CASE WHEN Col1 = 0 THEN 'Col1 Is In Error' END AS Result
FROM Table1
It doesnt work, so wondering what else I can try.
Life is a blast when you have a semi-automatic..