USP_GETRE7CONFIG

CREATE procedure dbo.USP_GETRE7CONFIG (@APPUSERID uniqueidentifier)
as
begin

      -- Open the symmetric key for decryption

      exec dbo.USP_GET_KEY_ACCESS;

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



        close symmetric key sym_BBInfinity;

end