You could just have another tab with the query and switch back to it. I guess it is a preference thing but i am not a big fan of switching...

JINX! I too assumed this to be homework. 😉

Are you wanting to add the single...

Excellent! I can tell it is almost quitting time....for the rest of the year. 😛

Jeff Moden has written some fantastic article on this site about doing that sort of thing. I think you would find his articles can get you the exactly what you...

Your insert are bit of a problem because you are inserting the field ID which you have marked as the primary key and there are duplicates.

If I understand the...

try something like this.

select item_num, pack, item_size, old_desc1, manufacturer_item_nbr, brand_name, opco_desc, flag, COUNT(distinct bid_price_old) as bidCount

from #mx

group by item_num, pack, item_size, old_desc1, manufacturer_item_nbr, brand_name, opco_desc, flag

Doesn't sound too bad. Now if there were some table create scripts and some sample data people would be easily able to help you. If you help us help you,...

You could just add select * from myTable to your open query window. 😉

In my experience the open table UI does not work very well. It is an editable grid...

The OP has record counts as comments in the query. 95 million and 190 million.

update a

set a.physical_location

= cast(Replace(cast(b.physical_location as varchar(MAX)),''+@currLoc+'', ''+@newLoc+'') as ntext)

from tbl_out_messages b

join tbl_out_messages a

on a.email_id = b.email_id

where b.physical_location...

Given nearly 300 million records being inserted it is going to take a bit of time no matter how you slice it. Retrieving the data could be a bottleneck but,...

smadden-534358 (12/22/2010)

---

I have been updating this field every time we change a directory path, for years. Never had a problem until today.

All of a sudden I am getting unexpected results.

this...

JMSM (12/22/2010)

---

Ok.

So can you send me a query where i can see in the output the following information.

The spid xxx that is locking spid yyy for x min (for example...

This one too is really unclear what you are looking for. The one thing I can say for certain is there is no query that will tell how long a...