Bruce W Cassidy (4/14/2009)

---

Lynn Pettis (4/14/2009)

---

Looks like a really good discussion developing in my opinion. Only one person really came out swinging hard at the beginning. The others...

Andy DBA (4/14/2009)

---

Also wondering if ownership chaining is still an issue with dynamic sql. Pretty sure I can write an sp that wraps sp_dont_touch_this(@someargument varchar(25)) in a cursor loop...

I am sorry that you feel that way.

One correction here, I never said that...

You have some weird hobbies, dude.

😛

Jeff Moden (4/14/2009)

---

I don't know what anyone else thinks, but this is a freakin' awesome thread. I don't believe such a huge collection of talent and code has ever...

Here's the code that I sent to Jacob Sebastian's challenge last month. Minus the two syntax errors that probably eliminated me from consideration 🙁 (gawd, I need a vacation!):

/*...

Here's an improved version of GSquared's set-based method.

create table #PR100 (Prime smallint primary key);

insert into #PR100

select T.N

from Tally T

left join (Select 2 as Prime

UNION...

Christian Buettner (4/14/2009)

---

RBarryYoung (4/14/2009)

---

Christian Buettner (4/14/2009)

---

I'll just jump in and risk making a fool of myself.

In one of my data import apps (Oracle to SQL Server), I use temp tables...

Thanks Bruce, I look forward to your future reviews. 🙂

Thanks, Joe! It's really great to here that from someone whose books played such a big part in my development...

I300I (4/14/2009)

---

The author makes the claim several times that there is no reason to ever use a cursor again with SQL Server 2005, because everything can be done with set-based...

I'm glad someone finally said that, Gus. All of my prime sieve stuff is in heavily nested CTE's and I did not want to to have to retrovert it...

Christian Buettner (4/14/2009)

---

I'll just jump in and risk making a fool of myself.

In one of my data import apps (Oracle to SQL Server), I use temp tables with varchar(500) fields...

Lynn Pettis (4/14/2009)

---

RBarryYoung (4/14/2009)

---

Manie Verster (4/14/2009)

---

...

RJ, I hope you don't mind but I'm going to jump in here. Barry, maybe RJ's requirements is small enough to justify a distribution list...

Not sure what you mean by "how" here, but SMO does accomplish almost all of its work by connecting to SQL Server and executing SQL commands. There are only...