I use source control for all DDL commands to be issued. Haven't found that it actually helps with anything, but it might some day. I think it makes...

With the clarification the you (Steve) meant functions, not errors, I agree.

But I think 80/20 isn't even applicable in many cases with in-house business software.

I have found great value to...

Gaby Abed (7/15/2009)

---

Kit G (7/15/2009)

---

My favorite Terry Prachett book is "The Fifth Elephant." Poor Vimes... my next favorite after that would be the book about Death.

I don't...

Kit G (7/15/2009)

---

My favorite Terry Prachett book is "The Fifth Elephant." Poor Vimes... my next favorite after that would be the book about Death.

I don't remember which...

What version of Access are they using? That may affect what you want to do.

I built and operated a complex application with SQL in back and Access on the...

Partitioning was pretty much invented to do exactly that!

Good job on getting it working.

I would separate the hierarchy query into a function, and then use Cross Apply to query it for each node. That's my first instinct anyway.

I can give a more...

There's a way to select from the tabs collection of the Excel object. I don't remember what it is, but if you Google/Bing/Yahoo/whatever that concept, you should be able...

ANSI_NULLS OFF is being deprecated. Microsoft recommends against using it.

Use either IsNull or Coalesce to handle the nulls in your string-build.

Would...

J.D. Gonzalez (7/14/2009)

---

GSquared (7/14/2009)

---

Have you considered doing the date math in a statement before the query? That usually helps that kind of thing tremendously. (Assign the value to...

Niiiiiiice!

Have you considered doing the date math in a statement before the query? That usually helps that kind of thing tremendously. (Assign the value to a variable and...

Jan Van der Eecken (7/14/2009)

---

Guys and Gals, you are freaking me out! I've been out of the office for not even six hours and there are already 38 new notifications...

RBarryYoung (7/14/2009)

---

GSquared (7/14/2009)

---

Gaby Abed (7/14/2009)

---

GSquared (7/14/2009)

I must be missing something. You have my screen name on the part that I wrote. Or are you asking if I'm The...

Gaby Abed (7/14/2009)

---

For a...