Dear listers,
My table ORDERS_DESPATCH has columns DATE_DESPATCD and DATE_REACHED. It also contains VEHICLE_NUMBER, GROSS_WT, DRIVER_ID, GOODS_INSURED.
How can I build a query for my form that will accept the date clicked from a calendar and display all the rows from the above table that shows which trucks are still on the road (i.e the trucks have been despatched but not yet reached). The date selected is stored in session variable and is not a column of the table.
SELECT * FROM ORDERS_DESPATCH WHERE (Date_selected) is BETWEEN DATE_DESPATCD and DATE_REACHED
I am using SQL SERVER 2008.
Thanks a lot for helping me, Pragya
...
Go to the complete details ...