UFN_EVENT_GETCATEGORY

Return

Return Type
nvarchar(100)

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN
@PROGRAMID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_EVENT_GETCATEGORY(
    @EVENTID uniqueidentifier,
    @PROGRAMID uniqueidentifier)
returns nvarchar(100)
with execute as caller
as begin
    declare @EVENTCATEGORY nvarchar(100);
    declare @PROGRAMCATEGORY nvarchar(100);

    select @EVENTCATEGORY = EVENTCATEGORYCODE.DESCRIPTION
    from dbo.EVENTCATEGORYCODE
    inner join dbo.EVENT on EVENTCATEGORYCODE.ID = EVENT.EVENTCATEGORYCODEID
    where EVENT.ID = @EVENTID;

    if @PROGRAMID is not null
        select @PROGRAMCATEGORY = PROGRAMCATEGORYCODE.DESCRIPTION
        from dbo.PROGRAMCATEGORYCODE
        inner join dbo.PROGRAM on PROGRAMCATEGORYCODE.ID = PROGRAM.PROGRAMCATEGORYCODEID
        where PROGRAM.ID = @PROGRAMID;

    return coalesce(coalesce(@EVENTCATEGORY, @PROGRAMCATEGORY), '')
end