>This may or may not be useful, depending on the exact data types being used. Note the 00:00 + 23:59 additions to the D tests:
>
>SELECT D, T, P, V
>FROM T_10199000
>WHERE D >= '2011-05-29 00:00' AND
>T >='15:00:00.0001' AND
>D <= '2011-05-30 23:59' AND
>T <= '14:59:59.9999'
>ORDER BY D, T ASC;

Doesn't help him, Tom, T is never both less than 14 and greater than 15 (I've already answered with workable alternatives).

Set