And what have you done so far to solve this particular problem? ...

And what have you done so far to solve this...

kaladharreddy15 (3/9/2010)

---

Write a query based on Customer table that returns oldest customer for each city. If there are more than

1 person with same oldest birth date, show all names for...

Sincerely doubt both Dr and MVP. Checked into the Doctorate Program at Colorado Technical University,...

I think someone has me confused with someone else here.

Elliott W (3/9/2010)

---

The code she posted would show you. When I did it, I did it the hard way with an ASCII chart that has hex values.. Hers...

Well, time for me to get ready to leave. I have another high school soccer game to officiate. I hope this one is better than the 10 -...

Take a close look at what I posted. There is an implicit conversion between binary and text in the assignment to the variable @x. All I did was...

Alvin Ramard (3/9/2010)

---

Lynn Pettis (3/9/2010)

---

lmu92 (3/9/2010)

---

Lynn Pettis (3/9/2010)

---

I think it's time for trip to the desert. Anyone care to join me? I'll put the hippo on a leash....

Two reasons, first of the chances of that system remaining in that state for any significant time is small. Things change and you should plan for it now, not...

Here is your query rewritten:

SELECT

prd.ProductID,

prd.Category,

prd.ProductCode,

prd.Description,

prd.Price,

ord.CustomerID,

...

lmu92 (3/9/2010)

---

May I join you?...

Looking at your code, this:

RIGHT OUTER JOIN dbo.EventDescription ED ON DEP.EventID = ED.EventID

should probably be this:

LEFT OUTER JOIN dbo.EventDescription ED ON DEP.EventID = ED.EventID

As this:

dbo.DefendantEventPros DEP is on the...

Agree, why would you do that on a production server?

Sure,...