Tuesday, 25 July 2017

Range Between Two Columns Validation Sql Server

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 

No comments:

Post a Comment