SQL InvoiceSequence question

Article View: borland.public.interbase.sql

Article #11390

Back to borland.public.interbase.sql Previous Next

#11390

From: Bram Schrijver
Date: Mon, 25 Nov 2002 22:20

14 lines
1123 bytes

Hello,

I need to generate a invoicenr with help of a SP. This Invoicenr should be
like this:

Year|Month|Sequencenumber

The sequencenumber has to start every month with 0001

How do I accomplish this?

TIA,

Jerri

Technical Details

Message-ID: <3de2a24d$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-05!sn-xit-06!sn-xit-04!supernews.com!news.maxwell.syr.edu!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,2d95c3f362f65af5,start
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-11-25 14:40:06 PST
From: "Bram Schrijver" <aa.schryver@tirol.com>
Newsgroups: borland.public.interbase.sql
Subject: SQL InvoiceSequence question
Date: Mon, 25 Nov 2002 23:20:27 +0100
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 80.121.133.203
Message-ID: <3de2a24d$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1038262861 80.121.133.203 (25 Nov 2002 14:21:01 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-05!sn-xit-06!sn-xit-04!supernews.com!news.maxwell.syr.edu!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail