USP_DATAFORMTEMPLATE_EDITLOAD_FINDERSETTINGS

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_FINDERSETTINGS
(
  @DATALOADED bit = 0 output,
  @TSLONG bigint = 0 output,
  @USERNAME nvarchar(100) = null output,
  @SECRETKEY nvarchar(250) = null output,
  @ADDRESS nvarchar(50) = null output,
  @CITY nvarchar(30) = null output,
  @STATEID uniqueidentifier = null output,
  @POSTCODE nvarchar(10) = null output,
  @COUNTRYID uniqueidentifier = null output,
  @NAICS nvarchar(6) = null output
)
as
  set nocount on;

  set @DATALOADED = 0;
  set @TSLONG = 0;
  set @COUNTRYID = (select dbo.[UFN_COUNTRY_GETDEFAULT]());
  exec dbo.[USP_GET_KEY_ACCESS];

  if (select count(1) from dbo.[SABOTEN]) = 1
  begin
    select top 1
      @DATALOADED = 1,
      @TSLONG = [TSLONG],
      @USERNAME = [USERNAME],
      @ADDRESS = [ADDRESS],
      @CITY = [CITY],
      @STATEID = [STATEID],
      @POSTCODE = [POSTCODE],
      @NAICS = [NAICS]
    from
      dbo.[SABOTEN];
  end
  else
  begin
    set @DATALOADED = 1;
    set @USERNAME = N'';
    set @ADDRESS = N'';
    set @CITY = N'';
    set @STATEID = null;
    set @POSTCODE = N'';
    set @NAICS = N'';
  end

  close symmetric key sym_BBInfinity;

  return 0;