Create Procedure to issue invoice number

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anthony - 05 Jun 2008 04:37 GMT

Hi,

I am new to SQL and I have a problem within the Web based application. The
problem is that when creating invoices the invoice number has reached the max
and therefore every invoice has the same invoice number. I would like to find
out what would be the script that I need to create that will issue a new
invoice number beginning with invoice number = 100000 and everytime the
invoice is created increment by 1 with a maximum of 999999. I will need to
add this code within the program that is written in ASP.

Thanks Very Much
Tony

Reply to this Message

Ramki - 20 Jun 2008 16:49 GMT

Hi Anthony,

I have question , i am in initial phas eto build database for windows CE .
Can i acceess database from ASP website. If possible how to do , please give
me some idea on this. How to make it work ASP with sql CE in windows CE.

REgards,
Rama

> Hi,
>
[quoted text clipped - 8 lines]
> Thanks Very Much
> Tony

Reply to this Message

Paul G. Tobey [eMVP] - 20 Jun 2008 17:01 GMT

Start a new thread for a new question. Don't hijack threads from other
people to start new discussions.

Paul T.

> Hi Anthony,
>
[quoted text clipped - 22 lines]
>> Thanks Very Much
>> Tony

Reply to this Message

Ginny Caughey MVP - 20 Jun 2008 18:27 GMT

Tony,

http://blogs.msdn.com/stevelasker/archive/2006/11/27/sql-server-compact-edition-
under-asp-net-and-iis.aspx

Ginny Caughey
Device Application Development MVP

> Hi Anthony,
>
[quoted text clipped - 22 lines]
>> Thanks Very Much
>> Tony

Reply to this Message