Is it possible to generate conditional identity or on the basis of another field(s)?
I need to populate a char(5) field with date wise numbering i.e. numbering begins from 1 for each new date. I have another identity field for uniqueness, but i need to populate this one for backward compatibility, as i was using composite unique keys earlier.