Grant Fritchey (8/21/2009)

---

Oh, sure. Shoving bamboo shoots under my finger nails is starting...

Bob Hovious (8/21/2009)

---

O Lynn, merciful patron Saint of Patience, tell us where we have failed.

Have we not asked the OP for data?

Have we not shown the OP the link to...

I do want to thank you for posting the DDL for your tables as well, but as Bob suggested, an abbreviated table schema (enough to work on your problem) is...

Persistant was she to get you to write bad code, hmm.

Thank...

I haven't worked in an Oracle shop so I never heard the term before. The closest term I am familiar with is a "cold start" and that meant everything...

It would also be of great benefit if you'd actually provide the DDL for the tables, the actual create table statements. That way we only need to cut/paste/run in...

Nicole Bowman (8/20/2009)

---

Jason and Steve, here in Australia it is often written into employment contracts/is a condition of employment, that you do not take any other paid employment at the...

trudye10 (8/20/2009)

---

Not sure what you mean.

This may not be the smartest question I'll ask in my life time. But here goes:

I have 3 trailers, one trl doesn't have...

That would occur if you use an INNER JOIN. If there is a possibility of there not being a detail record, then you would change that to a LEFT...

Alvin Ramard (8/20/2009)

---

Time for an Off Topic item:

Can anyone suggest a user group website that would be a great example of what a great user group website should look like?...

See above your last post.

First in addition to adding a WHILE (condition) BEGIN END to your code, you will need a second FETCH NEXT just before the END in the WHILE.

However, I may be...

Let's see, do I have those tables? No. Do I even have any data for those tables if I had them? No. Do I even fully...

MAK (8/20/2009)

---

when I try to drop the index I am getting error "An explicit DROP INDEX is not allowed on index 'dbo.crdtr.crdtr_ak1'. It is being used for FOREIGN KEY constraint...