USP_DATAFORMTEMPLATE_VIEW_MKTSEGMENTWHITEMAILREFRESHALL
The load procedure used by the view dataform template "White Mail Segments Refresh All Process View Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | The input ID parameter used to load the fields defined on the form. |
| @DATALOADED | bit | INOUT | Output parameter indicating whether or not data was actually loaded. |
| @SEGMENTCOUNT | int | INOUT | Segments to refresh |
Definition
Copy
CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_MKTSEGMENTWHITEMAILREFRESHALL]
(
@ID uniqueidentifier,
@DATALOADED bit = 0 output,
@SEGMENTCOUNT integer = null output
)
as
set nocount on;
set @DATALOADED = 1;
declare @NOW datetime = getdate();
select
@SEGMENTCOUNT = count([ID]) from dbo.[MKTSEGMENTWHITEMAIL]
where
[MKTSEGMENTWHITEMAIL].[STATUSCODE] = 0
or
([MKTSEGMENTWHITEMAIL].[STATUSCODE] = 1 and @NOW between isnull([MKTSEGMENTWHITEMAIL].[ACTIVEFROM], dateadd(d, -1, @NOW)) and isnull(dateadd(d, 1, [MKTSEGMENTWHITEMAIL].[ACTIVETO]), dateadd(d, 1, @NOW)));
return 0;