It's only now 12 months since I started working in offices again, having spent the previous 4.5 years mostly working from home (I had one year where I spent just...

Nicked, presumably.

Brandie Tarvin (7/14/2016)

---

ThomasRushton (7/14/2016)

---

Isn't that the time when...

Brandie Tarvin (7/14/2016)

---

Phil Parkin (7/14/2016)

---

Brandie Tarvin (7/14/2016)

---

jasona.work (7/14/2016)To quote the lady from Ghostbusters (1984): "WE GOT ONE!!"

:w00t:

The lovely Tahitian Island of Tahaa!

If I liquidate everything, I can come up with...

Cheese

Lastic

From your post:

SELECT Mission.Project_ID, Primary.Server_ID, Site.Site_ID, Connection.Connection_ID, Connection.Site_Start, Location.Latitude, Location.Longitude, Connection.Site_End, Location.Latitude AS End_Lat, Longitude AS End_Long

FROM Mission_ID LEFT JOIN

Primary ON Mission.Server_ID = Primary.Server_ID LEFT JOIN

Site ON Primary.Server_ID = Site.Server_ID...

Without going into specifics, the concept is something like this:

SELECT...

FROM MissionTable mt --mt is an alias

LEFT JOIN ReferenceTable rt1 ON mt.SourceLocation = rt1.Location

LEFT JOIN ReferenceTable rt2 ON mt.DestinationLocation = rt2.Location

quentin.harris (7/8/2016)

---

Awesome. Though i will be seeing flying pigs before i think i will be allowed to do this as it seems it can show sensitive information such as passwords....

quentin.harris (7/8/2016)

---

Thank you for this helpful article.

One further issue i have is i don't know how to actually post in SQL code.

I see people have it added and it seems...

Acid

tezsb (7/6/2016)

---

Yes, the CIO finally agreed with me that I could not do my job without sysadmin... although for some strange reason the 3rd Party company might still insist on...

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 in London who's...

Barley

Without looking in great detail, I suspect it might be something to do with this bit:

CASE WHEN ( @counted = 1 ) THEN @stock

You've declare @stock as an int; maybe...