It's SQL Saturday in Manchester for me, then a wedding on Sunday. We might drag ourselves to the flicks on Monday depending on how the Guinness flows at the...

Edit: Not needed after Thomas and Luis's answers.

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