Sql server select que busca rango de fechas y horas

[Libras]

Código SQL:

CREATE TABLE #temp(
fecha datetime
)
INSERT INTO #temp VALUES ('2011-08-08 08:30:00.000')
INSERT INTO #temp VALUES ('2011-08-08 09:30:00.000')
INSERT INTO #temp VALUES ('2011-08-08 10:15:00.000')
INSERT INTO #temp VALUES ('2011-08-08 12:30:00.000')
INSERT INTO #temp VALUES ('2011-08-09 08:45:00.000')
INSERT INTO #temp VALUES ('2011-08-09 09:25:00.000')
INSERT INTO #temp VALUES ('2011-08-09 20:45:00.000')
INSERT INTO #temp VALUES ('2011-08-10 08:32:00.000')
INSERT INTO #temp VALUES ('2011-08-10 08:49:00.000')
INSERT INTO #temp VALUES ('2011-08-10 16:45:00.000')
 
SELECT CONVERT(datetime,fecha) AS fecha FROM #temp WHERE fecha 
BETWEEN CONVERT(datetime,('2011-08-08' + ' ' + '08:30:00')) AND CONVERT(datetime,('2011-08-09' + ' ' + '09:25:00'))
 

No te sirve asi, de los datos que pones regresaria 6 renglones no??

2011-08-08 08:30:00.000
2011-08-08 09:30:00.000
2011-08-08 10:15:00.000
2011-08-08 12:30:00.000
2011-08-09 08:45:00.000
2011-08-09 09:25:00.000


Saludos!