how to generate sequence number containing date

Question

0.00/5 (No votes)

See more:

hi all,

i want to ask help on this problem.i dont know how to generate sequence number containing date and save to database.

Example: TicketId: 130422229000000001

130422 - date today (ticket issued)
22900 - station id
0000001 - sequence number

after that i want to store to database.

please help me on this

thanks in advance
musiw.

Posted 21-Apr-13 6:50am

musiw

Add a Solution

Comments

Maciej Los 24-Apr-13 10:51am

Do you want to that on server side using stored procedure?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Pepin z Hane · Answer 1 · 2013-04-21T07:37:00

Convert the date you want to start the sequence with to ticks.

C#

DateTime date = new DateTime(2013,4,21);
date.Ticks;

Than convert to ticks the maximal date you want to reach by the sequence and a step you want to increment with. For example you want to increment by one day:

C#

//Converting step
DateTime date2 = new DateTime(2013,4,22);
long step = date2.Ticks - date.Ticks;

At the end, create the sequence for example as a struct or better as a class.

C#

public class Sequence
{
    long minimum {get; set;}
    long maximum {get; set;}
    long step {get; set;}
    long actual {get; set;}
...
    public DateTime Next
    {
        get
        {
            actual += step;
            return new DateTime(actual);
        }
    }
}

gurc4n · Answer 2 · 2013-04-22T00:57:00

If this is a server code, and must run continuously, It is fine to get sequence from memory, but this is too risky.

I would use a 3 column table in database,
Column1 : Date
Column2 : Station ID
Column3 : Sequential number

And query database in insert statement something like;

insert into tblTest (DateVal, StationID, Seq) VALUES ("@p1","@p2",(select MAX(Seq)+1 From tblTest Where DateVal = @p3))
@p1 = Now.ToString("yyMMdd")
@p2 = 22900
@p3 = Now.ToString("yyMMdd")

If you are planning to use Sql2012 then take a look at;
http://msdn.microsoft.com/en-us/library/ff878091.aspx[^]

how to generate sequence number containing date

2 solutions

Solution 2

Solution 3

Add your solution here

Preview 0