Hi,

I have a table with more than 600,000 rows of data. I want to transfer the data from the field Group_ to INS_GROUP1 within the same table, in such a way that at the end both the fields have exactly the same data. I wrote the following update query.

Update XXX Set INS_GROUP1 = Group_ where INS_GROUP1 is null

After executing for two minutes, I got the following error..

[Microsoft][ODBC SQL SERVER driver]TimeOut expired.

On pressing OK, it stops exectuting the query further. I have the Driver number 3.70.09.61. Any help is highly appreciated.

Thanks
Bharat