I have event table where I need to select records between days. my statements look like
CONVERT(char(8),Event_Table.Event_time,112) BETWEEN 'request start date' AND 'request end date'
The Event_time is DateTime format.
Now everything look fine except from if I need the statement to request the date between as Date_start and Date_End any time it run. The idea is to request a for start and end period of date any time the scrpt run. the script will be run as DOS batch file.
View Complete Post