sorry Chris Morris-439714, it's PM

Hi Peter,

At present the testing table have 1628430 records. its' only a 5 month data. but in production it will be 5 time higher. It's a access control and...

Hi Peter,

The query is working fine; the only disadvantage is its execution time. It took long time to execute.

David's solution is much faster as compared to this. Thank...

Thank you David for your quick replay. Your query solved my problem.:-)

Thank u for your Help. This query helps me lot. but still have some problem.

for example i have an output with above query

EMPIDInTime ...

Thanks for your post. i am facing a similar issue. i have a table which is having the following fields and samle data

empid Transacttiondate ...