Hi,
Check the below sample...
CREATE TABLE [OD] (
[Mini] [int] NULL ,
[maxi] [int] NULL
) ON [PRIMARY]
GO
INSERT INTO OD (Mini, Maxi) VALUES (7,20)
INSERT INTO OD (Mini, Maxi) VALUES (40,50)
INSERT INTO OD (Mini, Maxi) VALUES (80,100)
DECLARE @MinVal AS INT
DECLARE @MaxVal AS INT
SET @MinVal = 87
SET @MaxVal = 90
IF EXISTS (SELECT OD.Mini, OD.Maxi
FROM OD
WHERE (@MinVal >= OD.Mini AND @MinVal <=OD.Maxi)
OR (@MaxVal >= OD.Mini AND @MaxVal <=OD.Maxi)
OR (OD.Mini >= @MinVal AND OD.Mini <=@MaxVal) )
SELECT 'Invalid' 'Status'
ELSE
SELECT 'Valid' 'Status'
Select OD.Mini, OD.Maxi from OD
Regards,
GVPrabu