USP_DATAFORMTEMPLATE_EDITLOAD_ETLCONFIGURATION

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_ETLCONFIGURATION
(
  @DATALOADED bit = 0 output,
  @DATEOPTION bit = null output,
  @REVENUESTARTDATE datetime = null output,
  @REVENUETYPELIST xml = null output,
  @TSLONG bigint = 0 output
)
as
  set nocount on;

  set @DATALOADED = 1;
  set @TSLONG = 0;

  select 
    @REVENUESTARTDATE = isnull([REVENUESTARTDATE], '1753-01-01'),
    @DATEOPTION = (case isnull([REVENUESTARTDATE], '1753-01-01')
    when '1753-01-01' then 0
    else 1
    end),
    @REVENUETYPELIST = dbo.UFN_ETLCONFIGURATION_GETREVENUETYPES_TOITEMLISTXML()
  from
    dbo.[ETLCONFIGURATION];

  return 0;