Sean Lange (6/16/2014)

---

SQLRNNR (6/16/2014)

---

Sean Lange (6/16/2014)

---

Koen Verbeeck (6/16/2014)

---

Sean Lange (6/16/2014)

---

I don't understand why so many soccer players have to roll around on the ground like they just broke their leg...

I'll ask again.

If the query with sample data in your original post does not give you want you want, what is the expected results you are looking for based on...

StephenNL (6/14/2014)

---

:(Sorry, again... I have been looking forward too early. I am now up to a certain point...

Did the following:

Copying the original database for test purposes, upgraded it to 90%...

itsgaurav (6/14/2014)

---

At first thanks for reply

pd_desp datatype is varchar(500).

Then if i not take this column in my sql .

And I include this in my index as mentioned above question.

Then...

Do you mean that you are still running in SQL Server 2000 Compatibility mode (Compatibility Mode 80)?

Based on the sample data provided what should the output look like?

Evil Kraig F (6/13/2014)

---

Lynn Pettis (6/13/2014)

---

Actually, I might be next year. Keeping an eye on SQL Server opportunities in Colorado Springs still and there isn't much there. Phoenix...

Evil Kraig F (6/13/2014)

---

Lynn Pettis (6/13/2014)

---

Sean Lange (6/13/2014)

---

You should get out...

Sean Lange (6/13/2014)

---

You should get out and play. That will really...

thomashohner (6/13/2014)

---

I got one that I just fired off a email about.

Double checking some reports that were previously built by the vendor. One of them kept crashing. Report Builder says...

I miss getting out on the pitch with the kids. It actually helps keep me feeling young.

jfogel (6/13/2014)

---

Lynn Pettis (6/13/2014)

---

jfogel (6/13/2014)

---

Ah, I see. Once I remarked out two of the select statements in Lynn's query before the cross apply I see just the desired result. Much...

Glad it worked. FYI, I did have to make some modify your inserts a bit to get things working. You should see the differences by...

jfogel (6/13/2014)

---

Ah, I see. Once I remarked out two of the select statements in Lynn's query before the cross apply I see just the desired result. Much more graceful method...

First of all, not all recruiters will have the same opportunities. There will be some overlap, I have seen it in job postings on the internet especially. I...