Valor con tabla entre fechas

[Libras]

Código SQL:

CREATE TABLE #temp(
monto INT,
limmenor INT,
limmayor INT
)
 
INSERT INTO #temp (monto,limmenor,limmayor) VALUES (200,2010,2011)
INSERT INTO #temp (monto,limmenor,limmayor) VALUES (300,2008,2009)
INSERT INTO #temp (monto,limmenor,limmayor) VALUES (400,2006,2007)
 
SELECT Monto FROM #temp WHERE datepart(YEAR,'10/05/2006') BETWEEN LimMenor AND LimMayor
 

Saludos!!