USP_EXPORTPROCESS_GETBYID

Retrieves an export business process from the database based on its ID.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_EXPORTPROCESS_GETBYID(@ID uniqueidentifier)
with execute as caller
as
    set nocount on;

    select ADHOCQUERYID,
        SMARTQUERYINSTANCEID,
        NAME,
        DESCRIPTION,
        EXPORTDEFINITIONID,
        SELECTIONID
    from dbo.EXPORTPROCESS
    where ID = @ID;