USP_DATAFORMTEMPLATE_VIEW_RE7WEBINTEGRATIONCONFIGURATION

CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_RE7WEBINTEGRATIONCONFIGURATION
(
  @CURRENTAPPUSERID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @PROVISIONINGKEY nvarchar(100) = null output,
    @RE7DBSERIALNUMBER nvarchar(100) = null output,
    @RE7WEBSERVER nvarchar(2047) = null output,
  @RE7USERNAME nvarchar(128) = null output
)
as
    set nocount on;

    -- be sure to set this, in case the select returns no rows
    set @DATALOADED = 1;

    select top 1 
           @PROVISIONINGKEY = RERPPROVISIONINGKEY,
           @RE7DBSERIALNUMBER = RE7DBSERIALNUMBER,
           @RE7WEBSERVER = RERPWEBSERVICEURL
    from dbo.RE7INTEGRATIONCONFIGURATION

  select
       @RE7USERNAME = RE7USERNAME
  from dbo.RE7INTEGRATIONCREDENTIALS
  where ID = @CURRENTAPPUSERID

    return 0;