UFN_TRIBUTE_GETSITES

Returns all sites for a given tribute.

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@TRIBUTEID uniqueidentifier IN

Definition

Copy


            create function dbo.UFN_TRIBUTE_GETSITES
            (
                @TRIBUTEID uniqueidentifier
            )
            returns table
            as
            return
            (
                select 
                    ID, SITEID
                from 
                    dbo.TRIBUTESITE
                where 
                    TRIBUTESITE.TRIBUTEID = @TRIBUTEID
            )