USP_IDMAPPER_SEGMENTATION_TO_SEGMENTATIONACTIVATEPROCESS

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

    -- write the SQL to fetch @TARGETID based on @SOURCEID

    select
        @TARGETID = ID
    from
        dbo.MKTSEGMENTATIONACTIVATEPROCESS
    where
        SEGMENTATIONID = @SOURCEID;

    return 0;