Glad that worked for you. 😀

Instead of a spreadsheet full of data that I then have to create a table (guessing at datatypes) and populate with your spreadsheet data can you just post ddl and...

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 in half...

SQLRNNR (6/16/2014)

---

george sibbald (6/16/2014)

---

Luis Cazares (6/16/2014)

---

David Burrows (6/16/2014)

---

Except that in one match already, with two different views of the goal...

itortu (6/16/2014)

---

Hello I am working on a query that needs to return the record order number with the most recent requested delivery date.

It seems to work most of the...

Something like this?

if exists

(

select count(*)

from #temp

having MAX(col1) - MIN(col1) > 30

or MAX(col2) - MIN(col2) > 30

)

select 'Fail'

else

select 'Good'

John Mitchell-245523 (6/16/2014)

---

Yes, he has had some pretty barmy ideas in...

TomThomson (6/16/2014)

---

I think that take is the Rugby players who haven't played soccer, and think that the game played by all the dive experts in professional soccer throughout Europe (especially...

Undeniably. As much as that really sucked it did finally force Blatter to admit...

David Burrows (6/16/2014)

---

Except that in one match already, with two different views of the goal line, one clearly showed no...

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 in half only to jump...

Oh yeah...I forgot to mention that once I go to My Account to view the link it almost always gives me a "connection reset" error.

ChrisM@Work (6/16/2014)

---

Ed Wagner (6/16/2014)

---

GilaMonster (6/14/2014)

---

Yup, that's pretty much how I feel.

I have little interest in sport. Most of the time that's fine. This week, I...

You're welcome. Glad that worked for you.

Jeff Moden (6/13/2014)

---

Sean Lange (6/13/2014)

---

While I agree that the DelimitedSplit8K function is likely to be of help here I want to point out that the datatype containing the csv data...