UFN_CHARITYCLAIMREFERENCENUMBER_GETSITES

Returns all sites for a given charity claim reference number.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@CHARITYCLAIMREFERENCENUMBERID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_CHARITYCLAIMREFERENCENUMBER_GETSITES
            (
                @CHARITYCLAIMREFERENCENUMBERID uniqueidentifier
            )
            returns table
            as
            return
            (
                select 
                    ID, SITEID
                from 
                    dbo.CHARITYCLAIMREFERENCENUMBERSITE
                where 
                    CHARITYCLAIMREFERENCENUMBERSITE.CHARITYCLAIMREFERENCENUMBERID = @CHARITYCLAIMREFERENCENUMBERID
            )