USP_MKTCOMMUNICATIONEFFORT_NAMESCHEMEPARTVALUES

CREATE procedure dbo.[USP_MKTCOMMUNICATIONEFFORT_NAMESCHEMEPARTVALUES]
(
  @SEGMENTATIONID uniqueidentifier
)
as
begin
  set nocount on;

  select
    [MKTSEGMENTATION].[DUEDATE],
    [MKTSEGMENTATION].[MAILDATE] as [LAUNCHDATE],
    [MKTSEGMENTATION].[CHANNEL],
    [MKTSEGMENTATIONACTIVATE].[APPEALID] as [APPEAL],
    [SITE].[NAME] [SITE]
  from
    dbo.[MKTSEGMENTATION]
    left join dbo.[MKTSEGMENTATIONACTIVATE] on [MKTSEGMENTATION].[ID] = [MKTSEGMENTATIONACTIVATE].[SEGMENTATIONID]
    left join dbo.[SITE] on [MKTSEGMENTATION].[SITEID] = [SITE].[ID]
  where
    [MKTSEGMENTATION].[ID] = @SEGMENTATIONID;
end