USP_DATAFORMTEMPLATE_VIEW_EVENTSEARCHINFO

CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_EVENTSEARCHINFO
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @EVENTTYPECODE integer = null output,
    @ISMULTIPART bit = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select
        @DATALOADED = 1,
        @EVENTTYPECODE = case 
            when EVENTAUCTION.ID is not null then 5 -- Auction

            when EVENT.PROGRAMID is not null then 10 -- Program event

            else 1 -- Event

        end,
        @ISMULTIPART = case
            when (select count(INNEREVENT.ID) from dbo.EVENT as INNEREVENT where INNEREVENT.MAINEVENTID = EVENT.ID) > 0 or (select count(EVENTHIERARCHY.ID) from dbo.EVENTHIERARCHY inner join dbo.EVENT as INNEREVENT on INNEREVENT.ID = EVENTHIERARCHY.ID where EVENTHIERARCHY.ID = EVENT.ID and INNEREVENT.MAINEVENTID is null) > 0
            then 1 else 0
        end --Taken from USP_DATAFORMTEMPLATE_LOAD_EVENTISMULTIPART

    from dbo.EVENT 
        left outer join dbo.EVENTLOCATION on EVENT.EVENTLOCATIONID = EVENTLOCATION.ID
        left outer join dbo.EVENTAUCTION on EVENT.ID = EVENTAUCTION.ID
    where EVENT.ID = @ID;

    return 0;