is it possible to find actual last accessed time though i restart the server every week?

I just gave 2 records..there are lot of records with dups

select emp_name,emp_email,class_date,

class_name,emailsent from emp_details.

kishore fdr@hotmail.com 2006-08-18 00:00:00.000 Tra N 

kishore fdr@hotmail.com 2006-08-20 00:00:00.000 Tra N 

here i need distinct class_date.

I am checking @per in my NOT IN caluse, uou can check my 1st  posted mesg.

syntax is working but unable to filter the records from not in

I want to check

1) select substring(Col001,1,2)from Emp where substring(Col001,17,2)='HE'

2) select substring(Col001,1,2)from Emp where substring(Col001,17,2)='DH' not in (select substring(Col001,1,2)from Emp where substring(Col001,17,2)='HE')

all the records in 2 shud match with 1...

I doubt if I can have multiple where clause in a single select statement

still am getting the same error.

what type of file I can save? and how can i do it?

check if your RAM has atleast 1GB.

fyi...there is nothing to do with database for this kind of error. sometimes recreating the report may work, just a blind try.