SELECT * FROM Games WHERE Team_ID=@t_id AND Date>'2012-05-01'
UNION
SELECT * FROM Games WHERE Team_ID=@t_id AND Date between '2012-04-01' and '2012-05-01'
-- ...