UFN_SMARTFIELDVALUEGROUP_CALCULATEMONEYVALUEGROUP
Returns the value group name valid for the given money value.
Return
| Return Type |
|---|
| nvarchar(100) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SMARTFIELDID | uniqueidentifier | IN | |
| @MONEYVALUE | money | IN |
Definition
Copy
CREATE function dbo.UFN_SMARTFIELDVALUEGROUP_CALCULATEMONEYVALUEGROUP
(
@SMARTFIELDID uniqueidentifier,
@MONEYVALUE money
)
returns nvarchar(100)
with execute as caller
as
begin
declare @GROUPNAME nvarchar(250)
select top 1 @GROUPNAME = GROUPNAME from dbo.SMARTFIELDVALUEGROUP
where @MONEYVALUE >= MONEYVALUERANGE and SMARTFIELDID = @SMARTFIELDID
order by MONEYVALUERANGE desc
return @GROUPNAME
end