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;