USP_FAFGROUPSUMMARYINFORMATION_CATEGORIZED_CALCULATE
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @NUMBERPROCESSED | int | INOUT | |
| @CHANGEAGENTID | uniqueidentifier | IN | |
| @CURRENTDATE | datetime | IN |
Definition
Copy
create procedure dbo.USP_FAFGROUPSUMMARYINFORMATION_CATEGORIZED_CALCULATE
(
@NUMBERPROCESSED integer = 0 output,
@CHANGEAGENTID uniqueidentifier = null,
@CURRENTDATE datetime = null
)
as
begin
set nocount on;
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output
if @CURRENTDATE is null
set @CURRENTDATE = GETDATE();
exec dbo.USP_FAFGROUP_CALCULATE_CATEGORIZEDCOUNTANDAMOUNT @NUMBERPROCESSED output, @CHANGEAGENTID=@CHANGEAGENTID, @CURRENTDATE=@CURRENTDATE
exec dbo.USP_FAFGROUP_CALCULATE_SOCIALMEDIAPOSTCOUNT @NUMBERPROCESSED output, @CHANGEAGENTID=@CHANGEAGENTID, @CURRENTDATE=@CURRENTDATE
select @NUMBERPROCESSED=COUNT(*) from dbo.FAFGROUPSUMMARYINFORMATION_CATEGORIZED (nolock)
where DATECHANGED = @CURRENTDATE
set @NUMBERPROCESSED = isnull(@NUMBERPROCESSED, 0)
end