DONATIONBATCHBATCHSYSTEMMESSAGE
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.[DONATIONBATCHBATCHSYSTEMMESSAGE] as select [DONATIONBATCHID] as ID, MESSAGETEXT, MESSAGETYPECODE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED, TS, TSLONG, MESSAGETYPE from (select *, row_number() over (partition by [DONATIONBATCHID] order by DATEADDED asc, TSLONG asc) as ROWNUM from dbo.[DONATIONBATCHBATCHSYSTEMMESSAGES] ) MESSAGES where ROWNUM = 1