>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.
Aman,
I suggest you use "INSTEAD OF INSERT" trigger for that.
http://msdn2.microsoft.com/en-us/library/ms175089.aspxCheers,
Zoran