USP_COMBINATION_DELETE

Executes the "Delete Combination" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the ID of the record being deleted.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the delete.

Definition

Copy



        CREATE procedure dbo.USP_COMBINATION_DELETE
        (
            @ID uniqueidentifier,
            @CHANGEAGENTID uniqueidentifier
        )
        as begin

          declare @contextCache varbinary(128);

                    /* cache current context information */
                    set @contextCache = CONTEXT_INFO();

                    /* set CONTEXT_INFO to @CHANGEAGENTID */
                    if not @CHANGEAGENTID is null
                        set CONTEXT_INFO @CHANGEAGENTID

                    /* delete the program groups before delete the combination. */
                    delete from dbo.PROGRAMGROUP 
                        where COMBINATIONID=@ID

                    /* reset CONTEXT_INFO to previous value */
                    if not @contextCache is null
                        set CONTEXT_INFO @contextCache

            exec USP_COMBINATION_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID
            return 0;

        end