UFN_PROGRAMTAX_GETPROGRAMS

This function returns programs associated with the specified tax id.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@TAXID	uniqueidentifier	IN

Definition

Copy



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