You'll need to join to your location table again, using the Site_Id for the end lat and long. At the moment, the query only joins on the start location...

I'm not sure what you're asking here. Your query looks like it already returns:

Via 1 : HA3 0AB , Via 2 : WC2A 1AB , Via 3 :...

Semi-colon

rob.carter 79958 (7/11/2016)

---

I'd echo the point about personal information, though I'm in a healthcare environment so it would be patient information that would be "cloudified" (I'm trademarking that).

As I'm in...

ChrisM@Work (7/6/2016)

---

BWFC (7/6/2016)

---

ChrisM@Work (7/6/2016)

---

BWFC (7/6/2016)

---

Phil Parkin (7/5/2016)

---

tindog (7/5/2016)

---

Michael L John (7/5/2016)

---

Can anyone in the U.K. (or is it K minus U these days?) make a recommendation for technical training? ...

ChrisM@Work (7/6/2016)

---

BWFC (7/6/2016)

---

Phil Parkin (7/5/2016)

---

tindog (7/5/2016)

---

Michael L John (7/5/2016)

---

Can anyone in the U.K. (or is it K minus U these days?) make a recommendation for technical training? We have...

Phil Parkin (7/5/2016)

---

tindog (7/5/2016)

---

Michael L John (7/5/2016)

---

Can anyone in the U.K. (or is it K minus U these days?) make a recommendation for technical training? We have a colleague...

Anandkumar-SQL_Developer (7/4/2016)

---

Hi friends ,

while i am running this simple merge program , there is an error...

Reported as spam

It's...

Eirikur Eiriksson (7/1/2016)

---

Brandie, you...

Yipes...

So even though BB4 5 is part of BB4 they may have different codes in the same database?

Could you split out the different customers' formats and codes into different lookup...

Does each postcode have its own area code? How do different parts of the same area relate? For example does BB4 have the same area code as BB4...

gkrs (7/1/2016)

---

I regularly have to mass update customers address areas when the postcode lookups for those areas are altered. e.g the lookup table can be something like below.

I usually do...

ThomasRushton (7/1/2016)

---

Donald