USP_DATAFORMTEMPLATE_VIEW_ETLCONFIGURATIONREVENUEDATE

Parameters

Parameter Parameter Type Mode Description
@DATALOADED bit INOUT
@REVENUESTARTDATE nvarchar(50) INOUT

Definition

Copy


CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_ETLCONFIGURATIONREVENUEDATE]
(
  @DATALOADED bit = 0 output,
  @REVENUESTARTDATE nvarchar(50) = null output
)
  as
    set nocount on;
    set @DATALOADED = 0;
    select
      @DATALOADED = 1,
      @REVENUESTARTDATE = isnull([REVENUESTARTDATE], '1753-01-01')
    from [dbo].[ETLCONFIGURATION];

    return 0;