Eric M Russell (2/9/2015)

---

It's easy to walk away from a job when you're young, your coworkers are difficult, and the pay is low. In that situation there is no internal...

Steve Jones - SSC Editor (1/21/2015)

---

DavidL (1/21/2015)

---

Steve: Can you explain a little why you don't think the German law can work, or is a good idea (don't remember exactly...

Steve: Can you explain a little why you don't think the German law can work, or is a good idea (don't remember exactly what you said about it)?

OCTom (12/12/2014)

---

don.schaeffer (12/12/2014)

---

I hope it's the last job as I've got just a few years to retirement but if things go downhill at my current position I will move.

Someone mentioned...

Hey! Good for you.

Stay hungry, stay curious!

Can you explain further the idea of selling recordings of the sessions to attendees? Is it an additional fee over an above the conference fee?

lshanahan (9/8/2014)

---

There's that old saw: "Some are born great, some achieve greatness, and some have greatness thrust upon them." (Wasn't that Shakespeare?)

So I guess we can re-phrase it: "Some are...

GilaMonster (9/5/2014)

---

Personally.... My father's an engineer (mechanical). I know what goes into studying to be an accredited engineer. I will never use the title Engineer for myself (I'm not one)

When,...

Steve Jones - SSC Editor (9/2/2014)

---

DavidL (9/2/2014)

---

All good advice. I like the first one (there is no plan), and the part about being true to yourself. It was...

All good advice. I like the first one (there is no plan), and the part about being true to yourself. It was only after about 20 years of...

wolfkillj (8/14/2014)

Did you try using the code mickyT posted above to find the rows where the vppblong value contains some character other than the digits 0-9, decimal point (.), and...

I didn't look for non-numeric characters as I have a degree of trust that there aren't any. That may be misplaced, though, so to be complete I will for...

This to me looks completely silly, but this is what I did to make it 'work'.

SELECT f.vpid#

,f.numlat As Latitude

,CONVERT(NUMERIC(12,8),f.[IntPart]) +

CONVERT(NUMERIC(12,8),f.[Mantissa]) AS Longitude

FROM

(

select vpid#, vppblat

, convert(numeric(12,8),vppblat) as numlat,

,CHARINDEX('.',vppblong)...

Sorry about the code not exactly matching (table creation vs insert statement)... I edited what I was working on to make it simpler and as much as I tried...

Well that's certainly a cautionary tale, and relevant to our field. It is unlikely that anyone presenting at a sql saturday event would be talking about anything even remotely...