Steve Jones - Editor (8/10/2010)

---

One more thing on the iPad/iPhone. There are quite a few libraries doing electronic lending of materials. Mine uses the Overdrive Media Console, which registers to...

mtillman-921105 (8/10/2010)

---

Jeff Moden (8/9/2010)

---

mtillman-921105 (8/9/2010)

---

Actually, this breaks a cardinal rule in database design - we are using one column for more than one kind of data. It answers two questions:...

I think one of those has a 'lending' capability,...

Chris Morris-439714 (8/6/2010)

---

Brandie Tarvin (8/6/2010)

---

In a total change of topic.

Out of the blue this a.m., I suddenly wanted Circus Peanuts. So, what is the one candy that you want right...

GilaMonster (8/6/2010)

---

Gianluca Sartori (8/6/2010)

---

Access is often a...

/* Give me all persons their relationship and the type

note the second join is INNER and the ON for it is defined first and the

ON Clause for the LEFT JOIN...

About time, we've only seen what, ten from you in the last two weeks?? :w00t: Don't you sleep?

Jack Corbett (8/5/2010)

---

Jon,

Where you place the criteria for OUTER JOIN's DOES make a difference. Whenever you place criteria in the WHERE clause that references a column in your OUTER...

Brandie Tarvin (8/5/2010)

---

--This is the hidden INNER JOIN Code

--that will only get me those stores that owe Royalties. Unless all stores in Florida owe,

--then there will be missing records.

Select...

WayneS (8/4/2010)

---

Steve Jones - Editor (8/4/2010)

---

I vote no. I like my watch. I don't want to have to buy a new one that has 10 digits.

Plus I have this cool...

Brandie Tarvin (8/4/2010)

---

Jack Corbett (8/4/2010)

---

Probably the most complex SQL I've had to write. Too many OUTER JOINs (business requires this design), and then parameters that could turn the...

Kit G (8/3/2010)

---

Jack Corbett (8/3/2010)

---

I definitely have opinions on those 2 topics, but I just don't think anything I say will lead to anything constructive. Having said that here's...

Stefan Krzywicki (8/3/2010)

---

jcrawf02 (8/3/2010)

---

I just don't think it's smart. It's very American to build in such a place to declare your freedom of religion, and a bold statement of reconciliation...

I just don't think it's smart. It's very American to build in such a place to declare your freedom of religion, and a bold statement of reconciliation (potentially), but not...

Alvin Ramard (7/31/2010)

---

That's not true. I know it may not be easy, but I cannot accept that kind of generalization!

One...