All Questions

Tagged with
1 question with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0
votes
0answers
219 views

NEXT VALUE FOR SEQUENCE inside a CASE Statement

I want to use a new SEQUENCE each year (See here: 'Id' with the format: YYYYNNNNNN with the NNNNNN part restarting each year ) However you can not use NEXT VALUE FOR inside a CASE statement. ...