USP_DATALIST_VOLUNTEERVOLUNTEERLOCATION

This datalist returns all volunteer locations for a volunteer.

Parameters

Parameter	Parameter Type	Mode	Description
@VOLUNTEERID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



            create procedure dbo.USP_DATALIST_VOLUNTEERVOLUNTEERLOCATION (@VOLUNTEERID uniqueidentifier)
            as
                set nocount on;

                select    VVL.ID, 
                        VLC.DESCRIPTION
                from dbo.VOLUNTEERVOLUNTEERLOCATION VVL
                inner join dbo.VOLUNTEERLOCATIONCODE VLC 
                    on VLC.ID = VVL.VOLUNTEERLOCATIONCODEID
                where VVL.VOLUNTEERID = @VOLUNTEERID
                order by VLC.DESCRIPTION;