The second link didn't seem to contain any reference to it?

I still wouldn't necessarily put the 'bug' to bed that easily though. If your bank 'clearly documented' the fact that...

I'm not sure that 'in the description of a system stored procedure which 97% of sql server users have never heard of' would necessarily...

Regex's are notoriously a...

I did - rule #1 of posting 🙂 I didn't do it with a selection, however.

If...

^(.+)$ is what's wanted.

Or, you could use an editor that has a 'Copy data as IN Clause'...

A couple of things

1) If you get into the habit of creating UDFs WITH SCHEMABINDING then it won't let you select * anyway - doing that gives a good performance...

Solomon Rutzky (5/28/2009)

---

1) Using the IEnumerable streaming method that I described here provides the greatest benefit when doing transformations in the application layer. I realize that my example code...

I don't really see the major benefit over using the SqlBulkCopy class here, which is also backwards compatible 2000 up.

A minor benefit that I can see is that you don't...

Lynn Pettis (4/20/2009)

---

Instead of searching through 300+ posts, could we get bruce t's problem posted to a new forum thread and a link added here for anyone interested to follow...

john.arnott (4/20/2009)

---

I certainly didn't mean to be heard as putting anyone down. I am having a hard time understanding why anyone feels the need to defend stop-gap measures as...

john.arnott (4/20/2009)

---

Whether sometimes you respond to a "situation" as best you can, even while aware that someone with different skills or experience may have offered a superior solution, I don't...

GSquared (4/20/2009)

---

You're the one who's said that you can't code correctly and fast. You can either code SQL correctly, or you can code SQL fast, but you can't do...

GSquared (4/20/2009)

---

I'm sorry that you don't know how to code well in SQL. I recommend, however, that instead of justifying it as "I just get the job done faster...

bruce.trimpop (4/16/2009)

---

I guess it boils down to:

"Is there a way to do a set based select statement that is based on the tables and columns used in the select...

Jeff Moden (4/15/2009)

---

Thomas (4/15/2009)

---

However, I have, in my travels, run into situations where even though a set-based solution existed, it performed worse than a cursor in that particular version of...