Thanks, But the actual result not like that.

I have 2 date ranges, the table values may fall in between this dates or may overlap the table values.

Pls help.....

Try this,

SET  NOCOUNT ON

CREATE TABLE testcase

(

 MyDecimal DECIMAL(2, 0) NOT NULL

)

CREATE INDEX ix_test ON testcase (MyDecimal)

DECLARE @v-2 REAL

SET @v-2=999999

INSERT INTO testcase VALUES (2)

SELECT * FROM...