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.SMARTFIELD932EB141BC8F4D52A04D64C39BFEDE38 where @SMARTFIELDINSTANCEID = '932eb141-bc8f-4d52-a04d-64c39bfede38'
Union All
select null as ID, ID as IntID , VALUE as VALUE from dbo.SMARTFIELD6222CB7F7E9246CCA6A697C08B71A3AA where @SMARTFIELDINSTANCEID = '6222cb7f-7e92-46cc-a6a6-97c08b71a3aa'
Union All
select ID as ID, null as IntID , VALUE as VALUE from dbo.SMARTFIELD9600E5F5AA9D492DA56C8A48F966953C where @SMARTFIELDINSTANCEID = '4efa1e1e-18dd-4583-8345-9f282d7b293e'