https://communities.sas.com/t5/SAS-Customer-Intelligence/What-will-be-happened-when-all-the-sequence-numbers-are-used-up/m-p/397982#M609 <P>What will be happened when all the sequence numbers are used up? E.g.: 5 digits; the number is now 99999. The next campaign will use 00001?</P><P>&nbsp;</P><P>Example:the current campaign code number is 99999. What is the campaign code number of the next created campaign, 00001? (Will it reset automatically?)</P> Fri, 22 Sep 2017 04:48:42 GMT Amarnadh 2017-09-22T04:48:42Z https://communities.sas.com/t5/SAS-Customer-Intelligence/What-will-be-happened-when-all-the-sequence-numbers-are-used-up/m-p/397982#M609 <P>What will be happened when all the sequence numbers are used up? E.g.: 5 digits; the number is now 99999. The next campaign will use 00001?</P><P>&nbsp;</P><P>Example:the current campaign code number is 99999. What is the campaign code number of the next created campaign, 00001? (Will it reset automatically?)</P> Fri, 22 Sep 2017 04:48:42 GMT https://communities.sas.com/t5/SAS-Customer-Intelligence/What-will-be-happened-when-all-the-sequence-numbers-are-used-up/m-p/397982#M609 Amarnadh 2017-09-22T04:48:42Z https://communities.sas.com/t5/SAS-Customer-Intelligence/What-will-be-happened-when-all-the-sequence-numbers-are-used-up/m-p/401014#M623 <P>Hi&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/160607">@Amarnadh</a>,</P> <P>&nbsp;</P> <P class="cs95E872D0"><SPAN class="cs8A70F0C8">If the campaign code is 99999, the next incremental value will be 100000 rather than 00001. After 100000, the next campaign codes will be 100001, 100002, 100003...</SPAN></P> <P class="cs95E872D0"><SPAN class="cs8A70F0C8">The other values in the sequence table behave in this same way.</SPAN></P> <P class="cs95E872D0">&nbsp;</P> <P class="cs95E872D0"><SPAN class="cs8A70F0C8">If you want it to behave differently (go back to 00001, you'll have to do it manually (edit the table) or programmatically (set the value).</SPAN></P> <P class="cs95E872D0">&nbsp;</P> <P class="cs95E872D0"><SPAN class="cs8A70F0C8">Hope that helps you.</SPAN></P> <P class="cs95E872D0">&nbsp;</P> <P class="cs95E872D0"><SPAN class="cs8A70F0C8">Cheers,<BR />Damo</SPAN></P> <P>&nbsp;</P> Wed, 04 Oct 2017 15:16:39 GMT https://communities.sas.com/t5/SAS-Customer-Intelligence/What-will-be-happened-when-all-the-sequence-numbers-are-used-up/m-p/401014#M623 Damo 2017-10-04T15:16:39Z