Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!c03.atl99!news.webusenet.com!news.maxwell.syr.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: t.kern@com4voice.de (minor07)
Newsgroups: comp.databases.theory
Subject: Creating a Trouble Ticket
Date: 3 Feb 2003 00:36:12 -0800
Organization: http://groups.google.com/
Lines: 13
Message-ID: <1f2ff280.0302030036.359221e5@posting.google.com>
NNTP-Posting-Host: 217.226.105.117
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1044261373 32134 127.0.0.1 (3 Feb 2003 08:36:13 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 3 Feb 2003 08:36:13 GMT
Xref: newsfeed1.easynews.com comp.databases.theory:24576
X-Received-Date: Mon, 03 Feb 2003 01:35:31 MST (news.easynews.com)

i´m just stucking in creating a troubleticket and dispatch db. What
our copany wants to implement is every time a customer reports a new
trouble a record in the following format should be created:

SA (always SA); Year (eg 03); Moth (eg: 01); Day (eg 23); runníng
Number from 000 to 999

--> SA030123003

Any idea how to implement the running number or the service request?
Thanks in advance.

TOM