USP_MKTSEED_TOGGLESTATUSPROMPT

Provides the prompt for the "Seed: Toggle Active Status" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Represents information to be displayed in the record operation prompt.
@NAME	nvarchar(154)	INOUT
@TOGGLETEXT	nvarchar(8)	INOUT

Definition

Copy



              CREATE procedure dbo.[USP_MKTSEED_TOGGLESTATUSPROMPT]
              (
                @ID uniqueidentifier,
                @NAME nvarchar(154) output,
                @TOGGLETEXT nvarchar(8) output
              )
              as
                set nocount on;

                select
                  @NAME = [NAME],
                  @TOGGLETEXT = (case when [INACTIVE] = 0 then 'inactive' else 'active' end)
                from
                  dbo.[MKTSEED]
                where
                  [ID] = @ID;

                return 0;