bruce.trimpop (4/14/2009)

---

Bruce

Here is the SQL i used on 2000 to re-create the data and tables - some mods were required, so hope you can check.

Is it possible that you...

Andy DBA (4/14/2009)

---

Just so it's clear I'm not asking about e-mail, notification services, etc. my question is: Is it possible to avoid loops (efficiently ;-)) when you need to...

bruce.trimpop (4/14/2009)

---

Unfortunately, the "readily consumable format" is a problem. Packaging something up that would cover all or most of the critical functional variations would be a bit time consuming. Thanks...

I don't...

sushila (4/14/2009)

---

As for the instances where you use cursors and no one else would be able to "improve either performance or readability with their removal", I volunteer Jeff Moden (Jeff...

Gaby

I have to admit - I wasn't too kind on your original article. BUT - it did spawn what was possibly the most interesting thread ever on SSC. You should...

Peter Hansen (4/14/2009)

---

I've read a number of "get rid of cursors" articles. None of them have addressed the issues that I have faced (and solved) with cursors. Perhaps this series...

Looking forward to part 2, sir. 😀

If you want an extra sounding board, let me know.

This is a really good article. Top Job 😀

That was pretty much my take on it 🙂

Code above - OP seems to have gone AWOL though!

declare @sql varchar(8000)

select @sql = ''

select @sql = @sql + 'UPDATE ' + name + ' set somecolumn = somecolumn + ''hello'';...

So, collectively we fixed a logic funny for you, and made it quicker to boot.

Go team! 😛

Ultimate props to Jeff on this one - I think the main key...

It's not deprecated, but it is a cursor under the hood. AFAIK.

You...

Another way, no cursor but still not amazing.

declare @sql varchar(MAX)

set @sql = ''

create TABLE #temp (ID INT IDENTITY (1,1) PRIMARY KEY CLUSTERED, ServerName sysname, DBName sysname,...

using convert with a specific style code (112 for example) give unambiguous results.