Thanks Guys, Thanks Steve!

If you could get me the DMO script- that would be really nice.

TIA

may I ask you why do you need that?

You could create view on the underlying table where you could specify the order of the columns the way you like.

just a guess. Do you know of any process which might be using this file. Then try to terminate that process and delete the file.

Try to incorporate your logic in the stored proc instead of running select/update statement on the front end.

It is also good for the speed and security reason.

Hi Derrick,

Thanks for your answers.

While I hope that it will be more comments, let me ask you the following:

When/what is the best time to run update statistics, defrag, reindex...

About 3 years ago, as fair as I remember, I ran accross the book 'SQL Server queries for Dummies'. Dark blue color. Don't quote me on that name, but the...

You might want to toggle SET ARITHABORT ON|OFF and SET ARITHIGNORE ON|OFF. Check BOL for more details.

SQL Server 2000 Programming by Robert Vieira from Wrox and

Ken Henderson's "The Guru's Guide to Transact-SQL" are probably the best.

Thanks again, Guys.

 I appreciate your help and comments!

Thanks Jeff!

You are really a GURU!

Any Gury around???

My table is relatively small.

So any idea(s) how to tackle this without subquery.

Cursor maybe or another solution.

Someone must have done it before!

TIA

Hi Tal,

I rearrange the table slightly ( which can be done in #temp)

Well. What I am trying to do is the following.

Client_Rep         Begin_Work       End_Work

Vitalio Arini         9.00                     9.45

Vitalio Arini         10.00                   12.00

Vitalio Arini         14.30                  ...

Thanks Tal for your response,

This is pretty much the existing structure and I cannot make any changes to it! What can I do is to create a temp table based...

Thank you,

I won't work. I have to, somehow, check the difference betwen End_work of the previous entry with Begin_work for the next entry for the same employee.

Any other ideas?