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