what is th eoutput of below SQL ?
SELECT CASE NEXT VALUE FOR [dbo].[SequenceObj]
WHEN 0 THEN 10
WHEN 1 THEN 20
WHEN 2 THEN 30
ELSE NULL
END AS [SeqCondition]