Tim Mitchell (11/28/2008)

---

Jeff Moden (11/22/2008)

---

GilaMonster (11/22/2008)

---

A senior DBA who doesn't know how to do performance monitoring or how to kill a connection? I could accept that of a junior with...

Jeff Moden (11/28/2008)

---

Actually, when I got this Laptop, the marketing brochure said that the CPU...

Yes, but that assumes that you already know that the Notes you want to look at are Supplier Notes.

What if you need to go the other way? ...

Heh. Interesting, they are using American "Billions", but still using the "and" improperly for American English.

The thing is that over here, "two hundred and twenty-three thousand dollars" legally can...

I assume in this scheme that you really intend for the "Notes" table to be a "NotesHeader" table? If so, then you probably...

it's not too bad, Grant. The presumption is that all tenants are using the same software and schema, just that every data row is tagged with a Tenant ID...

Oh it makes sense here, colloquially it's used all the time, it just isn't acceptable in financial English and text (the usual place for numbers-to-English transformations).

By the way, for the most part, it isn't the calculation that gives that speedup, it just makes it accurate.

What makes it faster is the inner subquery that...

Well, I snatched them from a post at the site that Chris Morris linked too (had to fix a bug in it though), which had no real explanation of it,...

Really? "One hundred and One" is acceptable in the UK? That really surprises me.

Yes, the latter is correct.

Thanks Jack.

Near as I can figure, this is what you want:

Select Max(sal)

Into abc

From...

You would probably have to start by telling us what a Spry database is and what it's requirements are.

Now there's a question that I have always wondered about...