UFN_SITEID_MAPFROM_EVENTEXPENSEID

Maps a EVENTEXPENSEID to a SITEID

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTEXPENSEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_SITEID_MAPFROM_EVENTEXPENSEID  
            (  
            @EVENTEXPENSEID uniqueidentifier  
            )   
            returns table
            as  
            return  
                select EVENTSITE.SITEID   
                from dbo.EVENTEXPENSE   
                left outer join dbo.EVENTSITE on EVENTEXPENSE.EVENTID = EVENTSITE.EVENTID  
                where EVENTEXPENSE.ID = @EVENTEXPENSEID;