UFN_PROGRAMFEE_GETFEE

This function returns a program's fee given its ID.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PROGRAMID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_PROGRAMFEE_GETFEE 
            (
                @PROGRAMID uniqueidentifier
            )
            returns table
            as return
                select 
                    PROGRAMFEE.ID,
                    PROGRAMFEE.FEEID,
                    FEE.NAME
                from 
                    dbo.PROGRAMFEE 
                left join 
                    dbo.FEE on PROGRAMFEE.FEEID=FEE.ID
                where 
                    PROGRAMID=@PROGRAMID and
                    FEE.ISACTIVE = 1;