USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTSUMMARYGROUPINFOTILE

CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTSUMMARYGROUPINFOTILE
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @CONSTITUENTIMAGE varbinary(max) = null output,
    @DESCRIPTION nvarchar(300) = null output,
    @GROUPCREATEDONDATE datetime = null output,
    @GIVESANONYMOUSLY bit = null output,
    @ISHOUSEHOLD bit = null output,
    @ISCOMMITTEE bit =null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select 
        @DATALOADED = 1,
        @CONSTITUENTIMAGE = CONSTITUENT.PICTURETHUMBNAIL,
        @DESCRIPTION = GROUPDATA.DESCRIPTION,
        @GROUPCREATEDONDATE = GROUPDATA.DATEADDED,
        @GIVESANONYMOUSLY = CONSTITUENT.GIVESANONYMOUSLY,
        @ISCOMMITTEE = dbo.UFN_CONSTITUENT_ISCOMMITTEE(@ID),
        @ISHOUSEHOLD = 
            case GROUPDATA.GROUPTYPECODE
                when 0 then 1
                else 0
            end
    from 
        dbo.CONSTITUENT
        inner join dbo.GROUPDATA on CONSTITUENT.ID = GROUPDATA.ID
    where 
        CONSTITUENT.ID = @ID;

    return 0;