USP_DATAFORMTEMPLATE_EDITLOAD_APPEALMAILINGSETUP_2

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_APPEALMAILINGSETUP_2
(
    @ID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier
)
as
begin

    set nocount on;

    select top(1)
        [MKTSEGMENTATION].[ACTIVE],
        [MKTSEGMENTATION].[NAME],
        [MKTSEGMENTATION].[DESCRIPTION],
        [MKTSEGMENTATION].[MAILDATE],
        [APPEALMAILING].[APPEALID],        
        [APPEALMAILING].[TSLONG],
        [MKTSEGMENTATION].[ADDRESSPROCESSINGOPTIONID],
        [MKTSEGMENTATION].[NAMEFORMATPARAMETERID],
        [APPEALMAILINGSETUP].[HOUSEHOLDINGTYPECODE],
        [MKTSEGMENTATION].CREATEOUTPUTIDSET,
        [MKTSEGMENTATION].OVERWRITEOUTPUTIDSET,
        [MKTSEGMENTATION].OUTPUTIDSETNAME

    from dbo.[APPEALMAILING]
    left join dbo.[APPEALMAILINGSETUP] 
        on [APPEALMAILINGSETUP].[ID] = [APPEALMAILING].[ID]
    inner join dbo.[MKTSEGMENTATION] 
        on [MKTSEGMENTATION].[ID] = [APPEALMAILING].[ID]    
    where [APPEALMAILING].[ID] = @ID;

    return 0;

end