UFN_MKTSEGMENTATIONASKLADDER_ENTRYAMOUNT
Returns the field name that can be used to select the entry amount for a given Ask Ladder.
Return
| Return Type |
|---|
| nvarchar(4000) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ASKLADDERID | uniqueidentifier | IN | |
| @JOINALIAS | nvarchar(128) | IN | |
| @FIELDNAME | nvarchar(128) | IN |
Definition
Copy
CREATE function dbo.[UFN_MKTSEGMENTATIONASKLADDER_ENTRYAMOUNT]
(
@ASKLADDERID uniqueidentifier,
@JOINALIAS nvarchar(128),
@FIELDNAME sysname
)
returns nvarchar(4000)
as
begin
declare @ret nvarchar(4000);
declare @OBJECTKEY nvarchar(400) = '';
select
@OBJECTKEY = isnull([OBJECTKEY], '')
from dbo.[MKTASKLADDER]
where [ID] = @ASKLADDERID;
if len(@FIELDNAME) = 0 or len(@OBJECTKEY) = 0 or @OBJECTKEY = '<none>' -- Fixed ladder
set @ret = '0';
else
set @ret = 'isnull([' + @JOINALIAS + '].[' + @FIELDNAME + '], 0)';
return @ret;
end;