UFN_GETPREVIOUSEVENTID
Get previous linked FAF event of the current event
Return
| Return Type |
|---|
| uniqueidentifier |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EVENTID | uniqueidentifier | IN |
Definition
Copy
create function [dbo].[UFN_GETPREVIOUSEVENTID]
(
@EVENTID as uniqueidentifier
)
returns uniqueidentifier
as
begin
declare @PEVENTID as uniqueidentifier;
select @PEVENTID = PRIORYEAREVENTID from [EVENTEXTENSION] where EVENTID=@EVENTID;
return(@PEVENTID);
end