UFN_EVENTCONFLICT_GETRESOURCES

Returns the resources for an event conflict

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTCONFLICTID	uniqueidentifier	IN

Definition

Copy



          create function dbo.UFN_EVENTCONFLICT_GETRESOURCES
          (
            @EVENTCONFLICTID uniqueidentifier
          )
          returns table
          as return
              select EVENTRESOURCE.ID AS ID,
                           EVENTRESOURCE.RESOURCEID,
                           EVENTRESOURCE.QUANTITYNEEDED
              from EVENTRESOURCE
              where EVENTRESOURCE.EVENTCONFLICTID = @EVENTCONFLICTID