USP_MKTSEGMENTATIONSEGMENT_GETREVENUESEGMENTINFO

CREATE procedure dbo.[USP_MKTSEGMENTATIONSEGMENT_GETREVENUESEGMENTINFO]
(
  @MKTSEGMENTATIONSEGMENTID uniqueidentifier
)
as
  set nocount on;

  select
    [MKTSEGMENT].[QUERYVIEWCATALOGID] as [RECORDSOURCEID],
    dbo.[UFN_MKTREVENUELETTER_MAKETABLENAME]([MKTSEGMENT].[QUERYVIEWCATALOGID]) as [REVENUELETTERTABLENAME],
    [MKTSEGMENT].[ID] as [MKTSEGMENTID],
    [MKTSEGMENTATIONSEGMENT].[SEGMENTATIONID],
    [MKTSEGMENTATIONSEGMENT].[PACKAGEID]
  from dbo.[MKTSEGMENTATIONSEGMENT]
  inner join dbo.[MKTSEGMENT] on [MKTSEGMENT].[ID] = [MKTSEGMENTATIONSEGMENT].[SEGMENTID]
  where [MKTSEGMENTATIONSEGMENT].[ID] = @MKTSEGMENTATIONSEGMENTID;

  return 0;