USP_DATALIST_ADVOCACYGROUP

Returns all AdvocacyGroup records.

Definition

Copy


CREATE procedure dbo.USP_DATALIST_ADVOCACYGROUP
as
    set nocount on;

    select 
        ADVOCACY_GROUP.[ID],
        ADVOCACY_GROUP.[GROUPID],
        ADVOCACY_GROUP.[TYPEID],
        ADVOCACY_GROUP.[NAME],
        ADVOCACY_GROUP.[DISTRICT],
        ADVOCACY_GROUP.[COUNTRY]
    from 
        dbo.ADVOCACY_GROUP