USP_MKTSEGMENTATION_GETACTIVEOFFERCOUNTFORPACKAGE

Returns the offer count for a specific package in an active marketing effort.

Parameters

Parameter	Parameter Type	Mode	Description
@SEGMENTATIONID	uniqueidentifier	IN
@PACKAGEID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.[USP_MKTSEGMENTATION_GETACTIVEOFFERCOUNTFORPACKAGE]
(
  @SEGMENTATIONID uniqueidentifier,
  @PACKAGEID uniqueidentifier
)
as
  set nocount on;

  declare @PACKAGETOTALOFFER table (
    [PACKAGEID] uniqueidentifier primary key,
    [TOTALOFFERS] int not null
  );

  insert into @PACKAGETOTALOFFER
    exec dbo.[USP_MKTSEGMENTATION_GETPACKAGEOFFERCOUNTSFORSEGMENTATION] @SEGMENTATIONID;

  select [TOTALOFFERS]
  from @PACKAGETOTALOFFER
  where [PACKAGEID] = @PACKAGEID;

  return 0;