USP_DATAFORMTEMPLATE_EDITLOAD_AWARDMANAGEMENTCONFIGURATION

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_AWARDMANAGEMENTCONFIGURATION
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @TSLONG bigint = 0 output,
  @AWARDMANAGEMENTTOKEN nvarchar(100) = null output,
  @AWARDMANAGEMENTURL nvarchar(2047) = null output
)
as

    set nocount on;

  -- Set DATALOADED and TSLONG in case no row exists in AWARDMANAGEMENTCONFIGURATION

    select 
    @DATALOADED = 0,
    @TSLONG = 0;

    select
        @DATALOADED = 1,
        @TSLONG = TSLONG,
        @AWARDMANAGEMENTTOKEN = AWARDMANAGEMENTTOKEN,
        @AWARDMANAGEMENTURL = AWARDMANAGEMENTURL
    from dbo.AWARDMANAGEMENTCONFIGURATION
    where ID = @ID;

  return 0;