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.SMARTFIELD9FF7B96ABBF2447EA61A1CCECB0FF33A where @SMARTFIELDINSTANCEID = '9ff7b96a-bbf2-447e-a61a-1ccecb0ff33a'
Union All
select null as ID, ID as IntID , VALUE as VALUE from dbo.SMARTFIELD2F1321C7907E4F1B913465DFFA33490B where @SMARTFIELDINSTANCEID = '2f1321c7-907e-4f1b-9134-65dffa33490b'
Union All
select ID as ID, null as IntID , VALUE as VALUE from dbo.SMARTFIELD9600E5F5AA9D492DA56C8A48F966953C where @SMARTFIELDINSTANCEID = '4efa1e1e-18dd-4583-8345-9f282d7b293e'