Hello Guys out there,

Thanks for the overwhelming response.

I lost my login pwd for the forum... haven't logged in for long time.

thanks every one guys.

It worked out.

I have tried doing it in SSIS, but saved it on the file system rather than the server object.

I should try it tomorrow.

Will try and post the reply.

Thanks for the...

Oops.. there seems to be an error in th SQL query at the over keyword.

Incorrect syntax near the keyword 'OVER'.

Mike,

Your solution doesn't seem to be working.

It ran for 1 1/2 hrs.

Seems too much as a solution.

Thanks.

480002 rows

Hi Mike,

Seems the query is taking a while to execute. I tried it for 20minutes.. not have seen any output.

Does this have any performance dependancy on the size of the...

Current Version I'm running is :

Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34 Copyright (c) 1988-2008 Microsoft Corporation Enterprise...