UFN_SMARTFIELDINSTANCE_GETMONEYVALUES

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@SMARTFIELDINSTANCEID uniqueidentifier IN

Definition

Copy
CREATE function dbo.UFN_SMARTFIELDINSTANCE_GETMONEYVALUES(@SMARTFIELDINSTANCEID uniqueidentifier)
returns table
as
return
select ID as ID, null as IntID , VALUE as VALUE from dbo.SMARTFIELDFAA4613EAA17455B9EFAE7EFE9315E17 where @SMARTFIELDINSTANCEID = 'faa4613e-aa17-455b-9efa-e7efe9315e17'
Union All
select ID as ID, null as IntID , VALUE as VALUE from dbo.SMARTFIELD9E5D803348EE402592CDE5200914AC91 where @SMARTFIELDINSTANCEID = 'ba482b05-117b-4fbf-a0f2-190c006b4cdd'
Union All
select ID as ID, null as IntID , VALUE as VALUE from dbo.SMARTFIELD563CB5B650254046955613E56258E7D1 where @SMARTFIELDINSTANCEID = '563cb5b6-5025-4046-9556-13e56258e7d1'
Union All
select ID as ID, null as IntID , VALUE as VALUE from dbo.SMARTFIELD0C72B1E7550B456CA8DE84FD10ADF2D5 where @SMARTFIELDINSTANCEID = '0c72b1e7-550b-456c-a8de-84fd10adf2d5'
Union All
select ID as ID, null as IntID , VALUE as VALUE from dbo.SMARTFIELD59509376DEEF41DFB57913F0AC529683 where @SMARTFIELDINSTANCEID = '59509376-deef-41df-b579-13f0ac529683'
Union All
select ID as ID, null as IntID , VALUE as VALUE from dbo.SMARTFIELDBE04BA97701E49038429192A79B94DA7 where @SMARTFIELDINSTANCEID = 'be04ba97-701e-4903-8429-192a79b94da7'
Union All
select ID as ID, null as IntID , VALUE as VALUE from dbo.SMARTFIELD7730360268124A77AEE9D8A40AEEE669 where @SMARTFIELDINSTANCEID = '77303602-6812-4a77-aee9-d8a40aeee669'
Union All
select ID as ID, null as IntID , VALUE as VALUE from dbo.SMARTFIELD1C931CD1D6D54008906A2635C13D526C where @SMARTFIELDINSTANCEID = '1c931cd1-d6d5-4008-906a-2635c13d526c'
Union All
select ID as ID, null as IntID , VALUE as VALUE from dbo.SMARTFIELD9692DFAA319444CAAC1F785C8FEE8003 where @SMARTFIELDINSTANCEID = '9692dfaa-3194-44ca-ac1f-785c8fee8003'
Union All
select null as ID, ID as IntID , VALUE as VALUE from dbo.SMARTFIELD2005F0F290324BC694E12CDBA05A7068 where @SMARTFIELDINSTANCEID = '2005f0f2-9032-4bc6-94e1-2cdba05a7068'
Union All
select ID as ID, null as IntID , VALUE as VALUE from dbo.SMARTFIELD4F065CB2EDED4F669998555F3C46C618 where @SMARTFIELDINSTANCEID = '4f065cb2-eded-4f66-9998-555f3c46c618'
Union All
select ID as ID, null as IntID , VALUE as VALUE from dbo.SMARTFIELD309FE5CD69294A67ABB274BE671C9EE1 where @SMARTFIELDINSTANCEID = '309fe5cd-6929-4a67-abb2-74be671c9ee1'
Union All
select ID as ID, null as IntID , VALUE as VALUE from dbo.SMARTFIELDC64D103321F341FC9A0FF69F97C6126D where @SMARTFIELDINSTANCEID = 'c64d1033-21f3-41fc-9a0f-f69f97c6126d'
Union All
select ID as ID, null as IntID , VALUE as VALUE from dbo.SMARTFIELD67A28B421B6C4E8F9DF8D857AE350CD1 where @SMARTFIELDINSTANCEID = '67a28b42-1b6c-4e8f-9df8-d857ae350cd1'
Union All
select ID as ID, null as IntID , VALUE as VALUE from dbo.SMARTFIELDFE10E3D809AD4524869505AB550B2193 where @SMARTFIELDINSTANCEID = 'fe10e3d8-09ad-4524-8695-05ab550b2193'
Union All
select ID as ID, null as IntID , VALUE as VALUE from dbo.SMARTFIELD1A97083C6C0F43E18203A83CFDDA1085 where @SMARTFIELDINSTANCEID = '1a97083c-6c0f-43e1-8203-a83cfdda1085'
Union All
select ID as ID, null as IntID , VALUE as VALUE from dbo.SMARTFIELD1E46A976B7BE4F74828235664996794F where @SMARTFIELDINSTANCEID = '1e46a976-b7be-4f74-8282-35664996794f'
Union All
select ID as ID, null as IntID , VALUE as VALUE from dbo.SMARTFIELDC88F6BDE38E840E78E2D1F9090EDB051 where @SMARTFIELDINSTANCEID = 'c88f6bde-38e8-40e7-8e2d-1f9090edb051'
Union All
select ID as ID, null as IntID , VALUE as VALUE from dbo.SMARTFIELDAA002CFAFFF043289E636BB71B76DA85 where @SMARTFIELDINSTANCEID = 'aa002cfa-fff0-4328-9e63-6bb71b76da85'
Union All
select ID as ID, null as IntID , VALUE as VALUE from dbo.SMARTFIELD634719A45FCD41908617763117A05834 where @SMARTFIELDINSTANCEID = '634719a4-5fcd-4190-8617-763117a05834'
Union All
select ID as ID, null as IntID , VALUE as VALUE from dbo.SMARTFIELD1802995943BC4BA39772AD92DA4F3304 where @SMARTFIELDINSTANCEID = '18029959-43bc-4ba3-9772-ad92da4f3304'
Union All
select ID as ID, null as IntID , VALUE as VALUE from dbo.SMARTFIELD92BBED279A1E4A94AF6407F77214BA76 where @SMARTFIELDINSTANCEID = '92bbed27-9a1e-4a94-af64-07f77214ba76'
Union All
select ID as ID, null as IntID , VALUE as VALUE from dbo.SMARTFIELD4DE86A501CC04864B5A0BD81BF0599DE where @SMARTFIELDINSTANCEID = '4de86a50-1cc0-4864-b5a0-bd81bf0599de'
Union All
select ID as ID, null as IntID , VALUE as VALUE from dbo.SMARTFIELDE444C7C26AEC4F37AA49DB1C88A8DA43 where @SMARTFIELDINSTANCEID = 'e444c7c2-6aec-4f37-aa49-db1c88a8da43'