UFN_EVENTHOLDLIST_GETEVENTHOLDS

This function returns an event hold list's holds given its ID.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTHOLDLISTID	uniqueidentifier	IN

Definition

Copy



        create function dbo.UFN_EVENTHOLDLIST_GETEVENTHOLDS
    (
      @EVENTHOLDLISTID uniqueidentifier
    )
        returns table
        as return
            select
                ID,
        HOLDCODEID,
        QUANTITY
            from
                dbo.EVENTHOLD
            where
                EVENTHOLDLISTID=@EVENTHOLDLISTID;