I removed a post relating to the Coalesce. Figured out I was being a dummy about it. Apologies.

Toni

Hi. Nice article. I enjoy a challenge to remove RBAR. Since I went ahead and made it, I'll add mine to the non-cursor alternatives with no...

Ooops... should have corrected the query for proper order of processing in the Where clause..

SELECT so.name as TableName,

case when si.indid=255 then 'Image_Text Info' when...

Here's another way to skin the cat which includes usage for Text/Image data

-- if you want to get the statistics updated, uncomment the next 2 Lines

--DBCC UPDATEUSAGE...

Matt, thank you very much for the explanation.

Toni

(** adding: in response to Charles **)

Hmmm.... I (re)read the article Jeff pointed to as the follow-up

and frankly...

I am not sure if this was covered somewhere in the numerous prior pages of discussion as I had a hard time going through all of them (pardon me if...

Since I went ahead and made the query which actually does provide the table and associated rowsize without cursors thought I would post it. (though I...

Thanks Jeff.

I was just looking through the code for the sp_MSforeach procedures (generated a Create for sp_MSforeachtable, sp_MSforeachworker and the sp_ MSforeach_worker) to see why the table one couldn't...

An alternative without cursor is:

Toni

You might want to determine if there might be any reason (legal requirements or self-preservation) to keep an archive of the deleted records in a separate database. This would...

If that is your Identity column, you would have to turn that off before making a change?

Toni

What Jack said. Looks like I am much slower than him.

Toni

I think this will do what you are after and will handle multiple updates.

Toni

--===== If the test table already exists, drop it

IF OBJECT_ID('mytable','U') IS NOT...

I would avoid using Checksum or binary or otherwise for uniqueness. It is not guaranteed to be unique as shown by this example I took from somewhere out on...