USP_SMARTFIELD_GETINSTANCEINFORMATION

            CREATE procedure dbo.USP_SMARTFIELD_GETINSTANCEINFORMATION
            (
                @ID uniqueidentifier
            )
            as
                select
                    SMARTFIELD.NAME,
                    SMARTFIELD.SMARTFIELDDATAFORMITEM,
                    SMARTFIELD.USEVALUEGROUP,
                    SMARTFIELD.TSLONG,
                    SMARTFIELD.SMARTFIELDCATALOGID,
                    SMARTFIELD.SYSTEMFIELD,
                    dbo.UFN_SMARTFIELDVALUEGROUP_GETGROUPS_2_TOITEMLISTXML(@ID) as SMARTFIELDVALUEGROUPS,
                    SMARTFIELDCATALOG.DISPLAYNAME,
                    SMARTFIELDCATALOG.FORMMETADATAXML as SMARTFIELDFORMMETADATAXML,
                    SMARTFIELD.DATEVALUEGROUPUNITCODE,
                    [SMARTFIELD].[SOURCEQUERYVIEWCATALOGID],
                    [SMARTFIELDCATALOG].[VALUERECORDTYPEID],
                    SMARTFIELDCATALOG.HASSITEFILTER,
                    dbo.UFN_SMARTFIELDSITES_GET_TOITEMLISTXML(SMARTFIELD.ID) as SITESSELECTED,
                    SMARTFIELD.SITEFILTERENABLEDFORINSTANCE,
                    SMARTFIELD.DESCRIPTION,
                    QUERYVIEWCATALOG.DISPLAYNAME as SOURCEQUERYVIEW,
                    SMARTFIELD.DATEVALUEGROUPUNIT,
                    SMARTFIELDCATALOG.DATATYPE,
                    SMARTFIELD.LASTRUNON,
                    case when [SMARTFIELDCATALOG].[DATATYPECODE] = 3 then isnull(SMARTFIELD.CURRENCYID, dbo.[UFN_CURRENCY_GETORGANIZATIONCURRENCY]()) else NULL end as [CURRENCYID],
                    case when [SMARTFIELDCATALOG].[DATATYPECODE] = 3 then dbo.[UFN_CURRENCY_GETDESCRIPTION](isnull(SMARTFIELD.CURRENCYID, dbo.[UFN_CURRENCY_GETORGANIZATIONCURRENCY]())) else '' end as [CURRENCY],
                    SMARTFIELD.SMARTFIELDCATEGORYCODEID,
                    SMARTFIELD.SHOWINFUNDRAISERONTHEGO
                from
                    dbo.SMARTFIELD
                    inner join dbo.SMARTFIELDCATALOG on SMARTFIELD.SMARTFIELDCATALOGID = SMARTFIELDCATALOG.ID
                    left outer join dbo.QUERYVIEWCATALOG on QUERYVIEWCATALOG.ID = SMARTFIELD.SOURCEQUERYVIEWCATALOGID
                where
                    SMARTFIELD.ID = @ID