-
New SQL field based on existing data fields
I am trying to form the syntax to produce a new field with contents from portions of existing SQL 2000 fields. Here is what I have:
Existing fields - customer number (5 digits, varchar)
Old sequence number (7 digits, varchar - 1st 2 digits indicate year, i.e. 07, 08)
I need to produce a new field in the following format -
2 digit year '-' customer number '-' incremental count based upon customer number
Example - Customer 10081, year 07
Desired new sequence number outcome - 07-10081-1
Next sequence number for the same customer - 07-10081-2, etc
When the customer number changes, the incremental count resets to '1'.
Any help here??
Thanks in advance
Dave
Similar Threads
-
By NeilFromBrazil in forum Database
Replies: 4
Last Post: 06-01-2006, 05:08 PM
-
By Brian Higgins in forum VB Classic
Replies: 1
Last Post: 11-26-2001, 11:19 PM
-
By Peter Prager (Canam Software) in forum vb.announcements
Replies: 0
Last Post: 08-15-2001, 10:48 AM
-
By Georgiana Trigg in forum VB Classic
Replies: 0
Last Post: 10-29-2000, 11:21 AM
-
By Aaron Longnion in forum authorevents.mitchell
Replies: 2
Last Post: 10-16-2000, 07:15 PM
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|