The status codes are not constants.
The seqno could be =1 or > 1.
the table name is ChgDate.
MS2000 SQL
Very new to SQL!
Type: Posts; User: dowens; Keyword(s):
The status codes are not constants.
The seqno could be =1 or > 1.
the table name is ChgDate.
MS2000 SQL
Very new to SQL!
Need a user function that will return top 3 status by seqno desc
data looks like
key seqno status
1 1 r
1 2 s
1 3 p
1 4 x