USP_GET_EVENT_DESIGNATIONS

    CREATE procedure dbo.USP_GET_EVENT_DESIGNATIONS
    (
        @EVENTID int,
        @ISDEFAULEONLY bit =1
    )
    as
    begin

        set nocount on;

        select EVENTDESIGNATION.ID as DesignationID,
                DESIGNATION.NAME as DesignationName,
                EVENTDESIGNATION.[DEFAULT] as IsDefault,
        DESIGNATION.ISACTIVE as IsActive

        from 
            dbo.EVENTDESIGNATION
        inner join dbo.DESIGNATION on EVENTDESIGNATION.DESIGNATIONID=DESIGNATION.ID
        inner join dbo.BBNCEVENTIDMAP as BM on BM.EVENTID =EVENTDESIGNATION.EVENTID
        where 
            BM.ID =@EVENTID and 1 = case when @ISDEFAULEONLY =1 and EVENTDESIGNATION.[DEFAULT] =1 then 1
                                     when @ISDEFAULEONLY =0 then 1
                                     end

    end