USP_DATAFORMTEMPLATE_VIEW_OLAPDATASOURCEVALIDATION_PAGEEXPRESSION

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@SOURCENAME	nvarchar(255)	INOUT
@OLAPDATASOURCEID	uniqueidentifier	INOUT
@MARTKEY	nvarchar(255)	INOUT
@VALIDATIONPARAMETERID	uniqueidentifier	INOUT

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_OLAPDATASOURCEVALIDATION_PAGEEXPRESSION]
    (@ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @SOURCENAME nvarchar(255) = null output,
    @OLAPDATASOURCEID uniqueidentifier = null output,
    @MARTKEY nvarchar(255) = null output,
        @VALIDATIONPARAMETERID uniqueidentifier = null output)

    as

      set nocount on;

      set @DATALOADED = 0;

      select @DATALOADED = 1,
      @SOURCENAME = [ODS].[SOURCENAME],
      @OLAPDATASOURCEID = [ODS].[ID],
      @MARTKEY = [ODS].[MARTKEY],
      @VALIDATIONPARAMETERID = [VAL].[ID]
      from dbo.[OLAPDATASOURCE] [ODS]
            inner join [OLAPDATASOURCEVALIDATIONPARAMETERS] [VAL] on [ODS].[ID] = [VAL].[OLAPDATASOURCEID] 
      where [VAL].[ID] = @ID;

      return 0;