UFN_SMARTFIELDINSTANCE_GETINTEGERVALUES
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SMARTFIELDINSTANCEID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_SMARTFIELDINSTANCE_GETINTEGERVALUES(@SMARTFIELDINSTANCEID uniqueidentifier)
returns table
as
return
select ID as ID, null as IntID , VALUE as VALUE from dbo.SMARTFIELD86EBC313BDBB4CAFB480161C01196BCF where @SMARTFIELDINSTANCEID = 'f47e471c-eb54-4a5d-a3fc-9ea0d3297b12'
Union All
select null as ID, ID as IntID , VALUE as VALUE from dbo.SMARTFIELDD336180199174F5AB1F80BC3647C11F4 where @SMARTFIELDINSTANCEID = 'd3361801-9917-4f5a-b1f8-0bc3647c11f4'
Union All
select null as ID, ID as IntID , VALUE as VALUE from dbo.SMARTFIELDB792158DE0E2414EB1339FCAED83EE03 where @SMARTFIELDINSTANCEID = 'b792158d-e0e2-414e-b133-9fcaed83ee03'
Union All
select ID as ID, null as IntID , VALUE as VALUE from dbo.SMARTFIELD9600E5F5AA9D492DA56C8A48F966953C where @SMARTFIELDINSTANCEID = '4efa1e1e-18dd-4583-8345-9f282d7b293e'