USP_IDMAPPER_MKTACKNOWLEDGEMENTPROCESS_TO_MKTEXPORTPROCESS

create procedure dbo.USP_IDMAPPER_MKTACKNOWLEDGEMENTPROCESS_TO_MKTEXPORTPROCESS
(
    @SOURCEID uniqueidentifier,
    @TARGETID uniqueidentifier output
)
as
    set nocount on;

    select
        @TARGETID = MKTSEGMENTATIONEXPORTPROCESS.ID
    from
        dbo.MKTACKNOWLEDGEMENTMAILINGPROCESSSEGMENTATION
    inner join  
        dbo.MKTSEGMENTATIONEXPORTPROCESS on MKTSEGMENTATIONEXPORTPROCESS.SEGMENTATIONID = MKTACKNOWLEDGEMENTMAILINGPROCESSSEGMENTATION.SEGMENTATIONID
    where
        MKTACKNOWLEDGEMENTMAILINGPROCESSSEGMENTATION.ACKNOWLEDGEMENTMAILINGPROCESSSTATUSID = @SOURCEID;

    return 0;