USP_DATAFORMTEMPLATE_VIEW_AWARDMANAGEMENTCONFIGURATION

CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_AWARDMANAGEMENTCONFIGURATION
(
    @DATALOADED bit = 0 output,
  @AWARDMANAGEMENTID uniqueidentifier = null output,
  @CONFIGURATIONEXISTS bit = null output,
  @AWARDMANAGEMENTTOKEN nvarchar(100) = null output,
  @AWARDMANAGEMENTURL nvarchar(2047) = null output  
)
as
    set nocount on;

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

    select 
    @DATALOADED = 1,
    @CONFIGURATIONEXISTS = 0;

    select
    @AWARDMANAGEMENTID = ID,
    @AWARDMANAGEMENTTOKEN = AWARDMANAGEMENTTOKEN,
    @AWARDMANAGEMENTURL = AWARDMANAGEMENTURL,
    @CONFIGURATIONEXISTS = 1
    from dbo.AWARDMANAGEMENTCONFIGURATION;

  return 0;