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;