USP_GETRERPUSERSERVERCONFIG

create procedure dbo.USP_GETRERPUSERSERVERCONFIG (@APPUSERID uniqueidentifier = null)
as
begin

      -- Open the symmetric key for decryption

      exec dbo.USP_GET_KEY_ACCESS;

        select top 1
      RE7INTEGRATIONCONFIGURATION.RERPPROVISIONINGKEY,
      RE7INTEGRATIONCONFIGURATION.RE7DBID,
      CREDS.RE7USERNAME,
      coalesce(convert(nvarchar(128), DecryptByKey(CREDS.RE7PASSWORD)),'') as RE7PASSWORD
        from dbo.RE7INTEGRATIONCONFIGURATION        
    outer apply (
              select RE7USERNAME, RE7PASSWORD, RE7WINDOWSAUTHENTICATION
              from dbo.RE7INTEGRATIONCREDENTIALS 
              where RE7INTEGRATIONCREDENTIALS.ID = @APPUSERID
        ) CREDS

        close symmetric key sym_BBInfinity;

end