How can I reset a sequence's value to 1 for every new year in C#
<p>I'm using the sequence to generate an identifier in the format YYYY-"sequence value" and the sequence value has to be reset to 1 for every new year. for example: for this year's value will be like 2011-3456. when new year comes, it should be set to like: 2012-0001.
Thanks in advance!</p>
