CELKO (8/11/2010)

---

JOINs of all kinds are done in left to right order and follow the usual rules for parens. Use your parens to be sure the order is right. ...

Great article Brandie, like how you offered multiple solutions and showed how you worked through them.

Jeff likes to use ABS(CHECKSUM(NEWID())) to generate random numbers, I haven't done any testing...

Gianluca Sartori (8/12/2010)

---

jcrawf02 (8/12/2010)

---

I'm sure that I read someone's blog/article about how table variables can be indexed during the declaration of the variable, and I think it was outside even...

I'm sure that I read someone's blog/article about how table variables can be indexed during the declaration of the variable, and I think it was outside even of a primary...

CirquedeSQLeil (8/11/2010)

---

That's a whole nutha topic there.

Pronunciation: \'wu?s-t?(r)-?shir-, -sh?r- also -?shi(-?)r-Function: noun

Etymology: Worcestershire, England, where it was originally made

Date: 1843

: a pungent sauce whose ingredients include soy, vinegar, and garlic

I...

Hmm, there's a Wooster Ohio, you...

Ray K (8/11/2010)

---

Kit G (8/11/2010)

---

Ray K (8/11/2010)

---

Ah -- if I remember my Rochester geography correctly, you were in Chili or Henrietta (or somewhere thereabouts), is that right? I can...

The Dixie Flatline (8/11/2010)

---

I was just remembering one of my favorite cartoons from "The Far Side", Chris. 🙂

The comics world lost a great humorist when...

Luke, check this out: http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/62731/%5B/url%5D, and I believe this would be usable in 2000 also, you'd just have to pass it as a string and convert to XMLdata, iirc.

Haven't found...

Gotcha, thanks, sorry to muddy the waters in a thread about 2000, wasn't thinking...

Nice article, David!

Hmm Luke, you're making me rethink something... so if I have a dataset I could potentially take the results of that dataset and pass as a Table-Valued Parameter into a...

Now I'm hungry. Favorite dish at a local Mexican joint, chicken, chorizo,...

once again, the power of The Thread is evident...I just walked into the break room to fill up my water, and there are Nerds just sitting there, waiting to be...

so.....treat your post as we normally do? :hehe: