I need to count the number of times a directory was accessed during a arbitrary time period.
Select count(directory) from tablename where Time between _____ AND ______
This forum may not be the best place to ask about TSQL but I would suggest you post it to
http://social.msdn.microsoft.com/Forums/en-US/transactsql/threads with your column names and their data-types.
Paras Doshi (Blog: ParasDoshi.com | Twitter:
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?