UFN_PROGRAMRESOURCE_GETRESOURCES

        CREATE function dbo.UFN_PROGRAMRESOURCE_GETRESOURCES
        (
          @PROGRAMID uniqueidentifier
        )
        returns table
        as return
            select PROGRAMRESOURCE.ID AS ID,
                         PROGRAMRESOURCE.RESOURCEID,
                         CASE WHEN RESOURCE.ISPERTICKETITEM <> 0 THEN 0
                            ELSE PROGRAMRESOURCE.QUANTITYNEEDED
                         END AS QUANTITYNEEDED,
                         RESOURCE.ISPERTICKETITEM,
                         CASE WHEN RESOURCE.ISPERTICKETITEM <> 1 THEN 0
                            ELSE RESOURCE.PERTICKETQUANTITY
                         END AS PERTICKETQUANTITY
            from PROGRAMRESOURCE
                inner join RESOURCE on PROGRAMRESOURCE.RESOURCEID = RESOURCE.ID
            where PROGRAMRESOURCE.PROGRAMID = @PROGRAMID