USP_GETDESIGNATIONIDBYEVENT

create procedure dbo.USP_GETDESIGNATIONIDBYEVENT (@EVENTID uniqueidentifier)WITH EXECUTE AS CALLER
as
begin
    set nocount on

    SELECT A.DESIGNATIONID
    FROM dbo.EVENT E 
    INNER JOIN dbo.APPEALDESIGNATION A
    ON E.APPEALID = A.APPEALID AND A.ISDEFAULT = 1
    WHERE E.ID = @EVENTID
end