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.SMARTFIELD1AD3570DED0C4D4B8831CE5263EBC7E3 where @SMARTFIELDINSTANCEID = '1ad3570d-ed0c-4d4b-8831-ce5263ebc7e3'
Union All
select null as ID, ID as IntID , VALUE as VALUE from dbo.SMARTFIELD646ACCA9F8A84A02875444D92CBBBBB0 where @SMARTFIELDINSTANCEID = '646acca9-f8a8-4a02-8754-44d92cbbbbb0'
Union All
select ID as ID, null as IntID , VALUE as VALUE from dbo.SMARTFIELD9600E5F5AA9D492DA56C8A48F966953C where @SMARTFIELDINSTANCEID = '4efa1e1e-18dd-4583-8345-9f282d7b293e'