USP_DATAFORMTEMPLATE_EDITLOAD_BBDWVALIDATIONPARAMETERS

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BBDWVALIDATIONPARAMETERS(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
      @INCLUDEEXTENSIONS bit = null output,
      @RUNAFTERETL bit = null output
)
as

    set nocount on;

    -- be sure to set these, in case the select returns no rows

    set @DATALOADED = 0
    set @TSLONG = 0

    select
    @TSLONG = [TSLONG],
        @INCLUDEEXTENSIONS = [INCLUDEEXTENSIONS],
    @RUNAFTERETL = [RUNAFTERETL]
    from 
        dbo.[OLAPDATASOURCEVALIDATIONPARAMETERS]
    where 
        [OLAPDATASOURCEID] = @ID

  select
      @DATALOADED = 1,
      @INCLUDEEXTENSIONS = isnull(@INCLUDEEXTENSIONS, 0),
    @RUNAFTERETL = isnull(@RUNAFTERETL, 0)

    return 0;