You may be onto something there. Before you can post anything you have to answer correctly a certain amount of QOTDs or read about posting etiquette and answer some...

I think you'll need to change the way you deal with this slightly.

I suspect that your period_name column is a char or varchar, so declaring @periodname as a date is...

Hi Dave

You will need to get yourself a polygon that defines the coastline. Once this is done and loaded into the database, you can use the spatial data types...

Thanks Andy. It's always good to know a bit of trivia, not that this is a trivial number:-)

I'd vote for Lynn's personally. His will return all the rows for Markers that have multiple rows all have Val 'Y'. This would become important if there are...

Louis Hillebrand (6/26/2014)

---

Interesting, but when I change the order of the rows in the insert (Mary before Anita) the order of the rows in query C changes.

The result of Query...

Hi

Interestingly enough I tried a similar test on 2012 for the originals and got elapsed times that so close as to be the same. It may have been the...

Thanks Andy ... learnt something new today. Hadn't used the escape clause before. Should be handy.

hey_igor (6/22/2014)

---

Kind of managed to get it working using a CTE

WITH CTE AS

(

Name,

StartPosition,

EndPosition,

'' AS Position,

Height

...

Hi

You may also want to have a look at APPLY as well then

http://www.sqlservercentral.com/articles/APPLY/69953/

http://www.sqlservercentral.com/articles/APPLY/69954/

Using APPLY you could end up with something like the following

SELECT

-- Original data from table

t.Name,

t.Start,

t.[End],...

Aw shucks .. thank you:blush:

Awesome:cool:

Dingo1Dave (6/18/2014)

---

...

I do have the below which as I am lead to believe will also help with the calculation.

ACOS(COS(RADIANS(90-@lat1))*COS(RADIANS(90-latitude)) +SIN(RADIANS(90-@lat1)) *SIN(RADIANS(90-latitude))*COS(RADIANS(@lon1-longitude)))*6371

This is being used in the calculation of the number...

wolfkillj (6/17/2014)

---

I found a place I can take Joe Celko's bait without bursting an aneurysm.

Joe's challenge: Implement Conway's Game of Life in SQL.

My solution on my blog.

The Schelling model...

Dingo1Dave (6/17/2014)

---

...

The bigger picture that I have is to try and build this out to cover larger areas of the world. I think trying to run a worldwide, land based...