USP_DATAFORMTEMPLATE_EDITLOAD_COMMUNITYMEMBERUSERNAME

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_COMMUNITYMEMBERUSERNAME
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @COMMUNITYMEMBERUSERNAME nvarchar(100) = null output
)
as

    set nocount on;

    set @DATALOADED = 0
    set @TSLONG = 0

    select top (1)
        @DATALOADED = 1,
        @TSLONG = TSLONG,
        @COMMUNITYMEMBERUSERNAME = [USERNAME]
    from
        dbo.NETCOMMUNITYCLIENTUSER
    where
        [CONSTITUENTID] = @ID
        and [ACTIVE] = 1
        and [DELETED] = 0
    order by
        [USERUPDATEDATE] desc;

    return 0;