UFN_PROGRAMGROUP_GETPROGRAMS

        CREATE function dbo.UFN_PROGRAMGROUP_GETPROGRAMS
        (
            @PROGRAMGROUPID uniqueidentifier
        ) returns table
        as
            return
            select
                PROGRAMGROUPPROGRAM.ID,
        PROGRAMGROUPPROGRAM.PROGRAMID,
        PROGRAM.NAME
            from
                dbo.PROGRAMGROUPPROGRAM
      inner join dbo.PROGRAMGROUP on
        PROGRAMGROUP.ID = PROGRAMGROUPPROGRAM.PROGRAMGROUPID
            left join dbo.PROGRAM on 
                PROGRAMGROUPPROGRAM.PROGRAMID = PROGRAM.ID
            where
                PROGRAMGROUP.ID = @PROGRAMGROUPID