USP_CONFIGURATIONEXPORTINSTANCE_GETINFORMATION

            create procedure dbo.USP_CONFIGURATIONEXPORTINSTANCE_GETINFORMATION
            (
                @ID as uniqueidentifier
            )
            as
                select
                    CONFIGURATIONEXPORTINSTANCE.ID as CONFIGURATIONEXPORTINSTANCEID,
                    coalesce(CONFIGURATIONEXPORTINSTANCE.CONFIGURATIONEXPORTDATAFORMITEM,'') AS CONFIGURATIONEXPORTDATAFORMITEM,
                    CONFIGURATIONDATACATALOG.ID as CONFIGURATIONDATACATALOGID,
                    CONFIGURATIONDATACATALOG.EXPORTFORMMETADATAXML as CONFIGURATIONDATACATALOGEXPORTFORMMETADATAXML,
                    CONFIGURATIONDATACATALOG.CONFIGURATIONDATASPECXML as CONFIGURATIONDATASPECXML
                from
                    dbo.CONFIGURATIONEXPORTINSTANCE
                    inner join dbo.CONFIGURATIONDATACATALOG on CONFIGURATIONDATACATALOG.ID = CONFIGURATIONEXPORTINSTANCE.CONFIGURATIONDATACATALOGID                    
                where
                    CONFIGURATIONEXPORTINSTANCE.ID = @ID;