Creating a logic for incrementing in database....

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

Hi,

Recently my boss asked me to create a functionality where the number of orders for a particular payment slip increments with the slip number. It is something like this:
If my invoice slip number is 12 and it has multiple orders so the number of orders should be like this - 1201, 1202, 1203 ....and so on.
How can i create a method which first time picks the invoice number from data base and add o01 at its end. And then for next time always it should inc the order number automatically. I have a idea in my mind where i can inc the invoice number by 01 but how to make sure it goes for the first time only. for all other times the existing work order numb should be increased. ?
Please suggest a idea.

Posted 17-May-12 18:42pm

Taresh Uppal

Add a Solution

1 solution

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)

Wendelius · Answer 1 · 2012-05-17T19:06:00

In my opinion this is something you should do when you query the data and you should not store that information in the database. The numbers may change if records are deleted, added between other records and so on. Calculated items shouldn't be generally stored.

To get the ordinal number in a query you can use ROW_NUMBER [^]

Depending on the situation you can get the slip number and the row number in separate columns and format them at client side (concatenate etc). Of course they can be converted to character and concatenated in the SQL statement but typically formatting shouldn't be done with SQL