Community technical support mailing list was retired 2010 and replaced with a professional technical support team. For assistance please contact: Pre-sales Technical support via email to sales@march-hare.com.
> Try this (tested on a CVSNT repo audited by MSSQL Server, but the > command should be almost identical: > > SELECT Command, [Date], Username, Hostname, VirtRepos > FROM SessionLog > WHERE > (Command='update' OR Command='checkout') > AND ([Date] > '2006-01-05') > AND ([Date] < '2006-02-01') > > Notice the brackets surrounding Date, needed on MSSQL since Date is a > reserved word and here is also defining a column name. I think that we changed column name that in CVSNT 2.5.04, so that SQL is probably for 2.5.03.2382? Regards, Arthur