UFN_MKTSEGMENTATIONSEED_GETSEEDCOUNT
Returns the number of seeds associated with a marketing effort.
Return
| Return Type |
|---|
| int |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SEGMENTATIONID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_MKTSEGMENTATIONSEED_GETSEEDCOUNT
(
@SEGMENTATIONID uniqueidentifier
)
returns int
as
begin
declare @SEEDCOUNT int;
/* Get the total seed count for all seed and package combinations in this mailing */
select @SEEDCOUNT = count([MKTSEGMENTATIONSEED].[ID])
from dbo.[MKTSEGMENTATIONSEED]
inner join dbo.[MKTSEGMENTATIONPACKAGE] on [MKTSEGMENTATIONSEED].[SEGMENTATIONID] = [MKTSEGMENTATIONPACKAGE].[SEGMENTATIONID]
where [MKTSEGMENTATIONSEED].[SEGMENTATIONID] = @SEGMENTATIONID;
return @SEEDCOUNT;
end