USP_STANDINGORDERSEXPORTPROCESS_GETPARAMETERS

Retrieves parameter settings for a given standing orders export process parameter set.

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


            CREATE procedure dbo.USP_STANDINGORDERSEXPORTPROCESS_GETPARAMETERS
            (
                @ID uniqueidentifier
            )
            as
                set nocount on;

                select 
                    [STANDINGORDERSEXPORTPROCESS].[ID], 
                    [STANDINGORDERSEXPORTPROCESS].[NAME], 
                    [STANDINGORDERSEXPORTPROCESS].[IDSETREGISTERID], 
                    [BUSINESSPROCESSVIEW].[ID] as [BUSINESSPROCESSVIEWID],
                    [STANDINGORDERSEXPORTPROCESS].[UPDATESTANDINGORDERS]
                from 
                    dbo.STANDINGORDERSEXPORTPROCESS 
                inner join
                    dbo.BUSINESSPROCESSVIEW on STANDINGORDERSEXPORTPROCESS.BUSINESSPROCESSVIEWID = BUSINESSPROCESSVIEW.ID
                where 
                    STANDINGORDERSEXPORTPROCESS.ID = @ID;