USP_ANALYTICSPROJECT_DELETE_PROMPT

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@PROMPTRESOURCEKEY	nvarchar(500)	INOUT
@PROMPT	nvarchar(100)	INOUT

Definition

Copy



                            CREATE procedure dbo.USP_ANALYTICSPROJECT_DELETE_PROMPT
                            (
                                @ID uniqueidentifier,
                                @PROMPTRESOURCEKEY nvarchar(500) output,
                                @PROMPT nvarchar(100) = null output
                            )
                            as
                            set nocount on;

                            if exists (
                                select 
                                    ID 
                                from dbo.MODELINGANDPROPENSITYDELIVERY 
                                where MODELINGANDPROPENSITYDELIVERY.ANALYTICSPROJECTID = @ID
                            )
                                set @PROMPTRESOURCEKEY = 'PROJECT_ASSOCIATED_WITH_SCORES';
                            else
                                set @PROMPTRESOURCEKEY = '$$are_you_sure_you_want_to_delete_this_project?';

                            return 0;