BATCHBBNCMEMBERSHIPBATCHSYSTEMMESSAGE
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| MESSAGETEXT | nvarchar(2000) | ||
| MESSAGETYPECODE | tinyint | ||
| ADDEDBYID | uniqueidentifier | ||
| CHANGEDBYID | uniqueidentifier | ||
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| TS | timestamp | ||
| TSLONG | bigint | yes | |
| MESSAGETYPE | nvarchar(28) | yes |
Definition
Copy
CREATE view dbo.[BATCHBBNCMEMBERSHIPBATCHSYSTEMMESSAGE] as select [BATCHBBNCMEMBERSHIPID] as ID, MESSAGETEXT, MESSAGETYPECODE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED, TS, TSLONG, MESSAGETYPE from (select *, row_number() over (partition by [BATCHBBNCMEMBERSHIPID] order by DATEADDED asc, TSLONG asc) as ROWNUM from dbo.[BATCHBBNCMEMBERSHIPBATCHSYSTEMMESSAGES] ) MESSAGES where ROWNUM = 1