UFN_MKTSEGMENTATIONSEGMENTLIST_GETCOSTPERRECORD
Returns the cost per record for a marketing effort's list segment.
Return
| Return Type |
|---|
| numeric(30, 20) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.[UFN_MKTSEGMENTATIONSEGMENTLIST_GETCOSTPERRECORD]
(
@ID uniqueidentifier
)
--Need to return a large number of decimal places, rather than a money data type, to
--minimize rounding errors that add up when expenses are summed.
returns numeric(30, 20)
as
begin
--Supports multicurrency
return dbo.[UFN_MKTSEGMENTATIONSEGMENTLIST_GETCOSTPERRECORD2](@ID, 0);
end