USP_MKTSEGMENTATION_GETACTIVETOTALCOST
Returns the total cost for a marketing effort.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SEGMENTATIONID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.[USP_MKTSEGMENTATION_GETACTIVETOTALCOST]
(
@SEGMENTATIONID uniqueidentifier
)
as
set nocount on;
declare @TOTALCOST money;
select
@TOTALCOST = isnull([TOTALCOST],0)
from dbo.[MKTSEGMENTATIONACTIVE]
where [ID] = @SEGMENTATIONID;
select @TOTALCOST as [TOTALCOST];
return 0;