USP_CONFIGURATIONEXPORTPROCESS_GETINSTANCEINFORMATION

            create procedure dbo.USP_CONFIGURATIONEXPORTPROCESS_GETINSTANCEINFORMATION
            (
                @CONFIGURATIONEXPORTPROCESSID 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,
                    CONFIGURATIONEXPORTINSTANCE.SEQUENCE
                from
                    dbo.CONFIGURATIONEXPORTINSTANCE
                    inner join dbo.CONFIGURATIONEXPORTPROCESS on CONFIGURATIONEXPORTPROCESS.ID = CONFIGURATIONEXPORTINSTANCE.CONFIGURATIONEXPORTPROCESSID
                    inner join dbo.CONFIGURATIONDATACATALOG on CONFIGURATIONDATACATALOG.ID = CONFIGURATIONEXPORTINSTANCE.CONFIGURATIONDATACATALOGID                    
                where
                    CONFIGURATIONEXPORTPROCESS.ID = @CONFIGURATIONEXPORTPROCESSID
                order by
                    CONFIGURATIONEXPORTINSTANCE.SEQUENCE;