UFN_PROGRAMFEE_GETPROGRAMS

This function returns programs associated with the specified fee ID.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@FEEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_PROGRAMFEE_GETPROGRAMS
            (
                @FEEID uniqueidentifier
            )
            returns table
            as return
                select 
                    PROGRAMFEE.ID,
                    PROGRAMFEE.PROGRAMID,
                    PROGRAM.NAME
                from 
                    dbo.PROGRAMFEE 
                left join 
                    dbo.PROGRAM on PROGRAMFEE.PROGRAMID = PROGRAM.ID
                where 
                    FEEID = @FEEID;