Thanks to all for your replies…

Thanks this is good also!!!

Thanks... let me read this infor.

Thanks a lot, I'll try the optimize first.

He have processes that load data into tables every 15 min and another process every 30  min. and web user viewing data around the same...

Yes, tables are being accessed via insert/update

or a SQL command that look for the transaction isolation level on the table

The reason I want to know, when people come to my site and the tables are in process mode I will send a message to...

Thanks,

insert into tablename01 select * from tabledump01 (process time 10sec)

select * from tablename01 (process time 5sec)

If I insert new records and it takes longer than the select, the select process first?

I...

Thanks you for your reply, it was very helpful.

Thanks

Thanks ericwallace,

that works fine, now how do i add the ',' to it.

i.e.

2794

2,794

Thanks SQLBill

This did not give me what I am looking for.

I'm going to dump the results in excel and format it that way for a quick fix.

I was trying to...

I’ve tried that but it is not working.

Here is how it looks in the table