DECLARE @FROMVALUE DECIMAL(15,3)=''
DECLARE @TOVALUE DECIMAL(15,3)=''
DECLARE @MESSAGE VARCHAR(MAX)=''
IF EXISTS(SELECT * FROM dbo.YOURTABLENAME AS C WHERE (C.F_VALUE <= @FROMVALUE AND C.T_VALUE >= @TOVALUE) OR ( (C.F_VALUE BETWEEN @FROMVALUE AND @TOVALUE ) AND (C.T_VALUE BETWEEN @FROMVALUE AND @TOVALUE))
)
BEGIN
SELECT @Message = 'Sorry !! Your Criteria Already Added !!'
RAISERROR (@Message, 16, 1);
END
DECLARE @TOVALUE DECIMAL(15,3)=''
DECLARE @MESSAGE VARCHAR(MAX)=''
IF EXISTS(SELECT * FROM dbo.YOURTABLENAME AS C WHERE (C.F_VALUE <= @FROMVALUE AND C.T_VALUE >= @TOVALUE) OR ( (C.F_VALUE BETWEEN @FROMVALUE AND @TOVALUE ) AND (C.T_VALUE BETWEEN @FROMVALUE AND @TOVALUE))
)
BEGIN
SELECT @Message = 'Sorry !! Your Criteria Already Added !!'
RAISERROR (@Message, 16, 1);
END
No comments:
Post a Comment