http://www.w3.org/ns/prov#value | - tem_no JOIN @schedule S ON O.order_no = S.order_noWHERE (S.start_date >= '12/17/2009' AND S.end_date < '12/21/2009') OR (S.start_date < '12/21/2009' AND S.end_date > '12/14/2009')ORDER BY run_no, O.order_no I ran the query in the dataset designer in Visual Studio 2003 (yup, SSRS 2000) and got data back including instructions.
|