USP_DATAFORMTEMPLATE_LUMINATEONLINEDATACONNECTORSETTINGS_EDITLOAD

create procedure dbo.USP_DATAFORMTEMPLATE_LUMINATEONLINEDATACONNECTORSETTINGS_EDITLOAD
(
  @DATALOADED bit = 0 output,
    @USERNAME nvarchar(255) = null output,
    @PASSWORD nvarchar(255) = null output,
  @URL nvarchar(1000) = null output,
  @SYNCPARTITIONID nvarchar(255) = null output,
  @BDEOPERATIONID nvarchar(10) = '900' output
)
as
begin
    -- be sure to set this, in case the select returns no rows

    set @DATALOADED = 0;

  exec dbo.USP_GET_KEY_ACCESS;

  select top 1 
    @DATALOADED = 1,
      @USERNAME = USERNAME,
      @PASSWORD = convert(nvarchar(255), DecryptByKey(PASSWORD)),
      @URL = URL,
    @SYNCPARTITIONID = SYNCPARTITIONID,
    @BDEOPERATIONID = BDEOPERATIONID
    from dbo.LUMINATEONLINEDATACONNECTORSETTINGS

    close symmetric key sym_BBInfinity;    

  set @BDEOPERATIONID = coalesce(@BDEOPERATIONID, '900');

    return 0;
end