Sequence

From: Mike (anonymous_at_discussions.microsoft.com)
Date: 08/17/04 

Date: Tue, 17 Aug 2004 14:38:27 -0700

I need to create sequence numbers for a column in a table,
I wanted to find out how can I create it?

I have a column, depending if the file type ='A'
the fileNumber should be 'A001'
The next record could have the file type='B', in this
case the filenumber should be 'B001',
if the next file type = 'A', the filenumber should be
'A002',
if the next file type = 'A', file number should be 'A003',
if the next file type = 'B', file number should be
'B002', so on...

I want to maintain more than one sequences for a column
and each one should preceed with an ALPHA.
What's the best way to do this?

Remeber, I can't define it in EM as the sequence changes
with file type.

Thanks in advance for your help!
-Mike

Relevant Pages

  • Re: Sequence
    ... 3rd record or so forth in relational database. ... I will have a table - file type is one field and file ... These numbers should bear their own sequence ... >* Expected output based on the provided sample data. ...
    (microsoft.public.sqlserver.mseq)
  • Re: Sequence
    ... >case the filenumber should be 'B001', ... I can't define it in EM as the sequence changes ... >with file type. ... Expected output based on the provided sample data. ...
    (microsoft.public.sqlserver.mseq)
  • Re: connecting vs. connecting to media
    ... What file type are the files that cause this issue? ... depending upon what file type it is. ... Windows Media Development Team ... audio plays but screen is a still picture. ...
    (microsoft.public.windowsmedia.player)