Id Value 1 Created 2 removed 3 N/A
SELECT DISTINCT 1 AS StId, CASE WHEN SD.Id = 0 THEN 'N/A' ELSE CASE WHEN SD.Id != 0 THEN 'Created' ELSE 'Removed' END END AS DisplayValue FROM Student SD
Id Value 1 Created 1 Removed 1 N/A
ID INT, IDENTITY Desc NVARCHAR(MAX)
SELECT s.ID, d.Desc FROM Students s JOIN DisplayValues d ON s.ID = d.ID
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)