i can't post the query , because of restrictions in my Company.

will post sample tables data and query i am using.

in the mean while can any one directing me...

checking chris.

thanks for the quick help.

See you soon..

hi ,

it fullfilled my requirement. but not able to understand cross apply with x symbol .

pls explain if dont mind.

i have 5 diferent tables minimum they contains 10 millions of records in it. every table contains column called date , and also it may contains nearly 25 days of...

i am not deleting all the records. i am Deletig on some logic.thats y i am using delete statement.

Thanks for the quick response.. as always you are quick.. i always read ya replies to other posts and learn from you .

thanks again..

Thanks ..it is working fine for me.

Thanks for the explanation !!!!

:-):-):-)

can you please why did you used Having clause in the query ?

i am just curious !!

It is working for now.

Thanks for the prompt response.

Thanks again..:-):-):-)

Thansk folks!!! i learned a lot here by posting the question...

thanks again!!!!

Thanks Luis!!

thanks.. yes you were right... i need to use deptno only...

use DBCC shrinkfile(filename, 0).

it shirnks unused a memory...it works..!!!

Thanks Lynn and to others.

I have been created to Trace file which capture the transacations performed on table by any user...

Thanks again!!!