I have the following code statement:
SELECT Id, Name, Type,
CASE Type
WHEN Type = 0 THEN 'Public'
WHEN Type = 1 THEN 'Internal'
ELSE 'Unknown'
END as TypeString
FROM table
However, this is resulting like this:
Why is this not working?
Please can you upload the query profile ?