USP_VIEW_APPEALMAILING_BASICINFO

CREATE procedure dbo.[USP_VIEW_APPEALMAILING_BASICINFO]
(
    @SEGMENTATIONID uniqueidentifier
)
as
begin

    select
        ADDRESSPROCESSINGOPTION.NAME [ADDRESSPROCESSING],
        NAMEFORMATPARAMETER.NAME [NAMEFORMAT],
        MKTSEGMENTATION.HOUSEHOLDINGONERECORDPERHOUSEHOLD as [HOUSEHOLDINGONERECORDPERHOUSEHOLD],
        APPEALMAILINGSETUP.ESTIMATEDNETREVENUE as [ESTIMATEDNETREVENUE]
    from
        MKTSEGMENTATION
    inner join
        ADDRESSPROCESSINGOPTION on ADDRESSPROCESSINGOPTION.ID = MKTSEGMENTATION.ADDRESSPROCESSINGOPTIONID
    inner join
        NAMEFORMATPARAMETER on NAMEFORMATPARAMETER.ID = MKTSEGMENTATION.NAMEFORMATPARAMETERID
    inner join
        APPEALMAILINGSETUP on APPEALMAILINGSETUP.ID = MKTSEGMENTATION.ID
    where
        MKTSEGMENTATION.ID = @SEGMENTATIONID

end