UFN_SITEID_MAPFROM_EVENTIDAPPEALID
Maps an EVENTID and an APPEALID to a SITEID
Return
| Return Type |
|---|
| uniqueidentifier |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EVENTIDAPPEALID | nvarchar(72) | IN |
Definition
Copy
create function dbo.UFN_SITEID_MAPFROM_EVENTIDAPPEALID
(
@EVENTIDAPPEALID nvarchar(72)
)
returns uniqueidentifier
as
begin
declare @ID uniqueidentifier;
select
@ID = [APPEAL].[SITEID]
from
dbo.APPEAL
where
[APPEAL].[ID] = right(@EVENTIDAPPEALID, 36);
return @ID;
end