gregory.anderson (4/16/2010)

---

That example of the cross apply stuff makes it look so easy. Once the article mentioned it was just like a method in programming, it kind of clicked for...

Chris Morris-439714 (4/16/2010)

---

Are you not satisfied working with SQL anymore? And do you sell knifes as well wearing...

huston.dunlap (4/15/2010)

---

That would work, with the only note that it tremendously increases the amount of CASE statements I need.

Because every entry is now unique to every record, the number of...

If there is the need to store more than 8 products, I'd question the purpose of CustomerWithMultipleProducts, too.

In that case I'd most probably use that table to store the unique...

The CI stands for CaseInsensitive. Otherwise you'd have a CS collation. No need for further...

If the data need to be stored in the intermediate table in separate columns I'd use the CrossTab approach as described in the related link in my signature.

But if the...

CirquedeSQLeil (4/15/2010)

---

lmu92 (4/15/2010)

---

But to make sure you're still able to read what you wrote as the "upper limit" and "enough to help the ideas flow freely" as the "lower limit"...

Based on what you just wrote I would insits on getting a special role to be set up by the vendor to meet your requirements.

It should benefit "both sides". I...

Alvin Ramard (4/15/2010)

---

Roy Ernest (4/15/2010)

---

What is the best way to beat writer's block? Anybody have any ideas? I am half way through an article and now I cant seem to...

David Webb-200187 (4/15/2010)

---

Yes, it's a strange position to be in. I just found out that the outsourcer, who shall remain nameless, was paid to migrate some databases from SQL...

Well, Wayne, I appreciate the compliment :blush:

But it looks much more complicated than it really is:

Those "x"hundred lines of code include quite a few descriptive comments (which is, to be...

You consider my statement as "blah blah blah"? I'm depressed now. :crying:

@chris-2: When did you start promoting loops??? :crying:

Or do I miss something that prevent doing it set based?

David Webb-200187 (4/15/2010)

---

I'm in a position now where I am managing an outsorced DBA service. I'd like to be able to look at everything at the server and database...

Even if I'm not Jeff ( 😀 ) but promoting his great articles because those are simply the best ones I found related to this subject, I'd use ROW_NUMBER() to...