Gary Varga (11/1/2016)

---

It seems a little worrying how many will not use the command line. I am not referring to your average citizen but your average IT professional. I have...

One barrel...

ChrisM@Work (11/1/2016)

---

Luis Cazares (10/31/2016)

---

Sean Lange (10/31/2016)

---

jasona.work (10/31/2016)

---

Ed Wagner (10/31/2016)

---

Sean Lange (10/31/2016)

---

jasona.work (10/31/2016)

---

ChrisM@Work (10/31/2016)

---

Sean Lange (10/31/2016)

---

ChrisM@Work (10/31/2016)

---

Sean Lange (10/31/2016)

---

Ed Wagner (10/31/2016)

---

ThomasRushton (10/31/2016)

---

Wryan138 (10/30/2016)

---

So in lieu of some marvelous SQL wizardry, I'm...

jasona.work (10/26/2016)

---

Brandie Tarvin (10/26/2016)

---

jasona.work (10/26/2016)

---

Phil Parkin (10/26/2016)

---

HanShi (10/26/2016)

---

BLOB_EATER (10/26/2016)

---

I liked Eric's response - "get a job you...

Gary Varga (10/26/2016)

---

BWFC (10/26/2016)

---

...Maybe a longer date should have been chosen but when 01/01/2020 was picked, no one could have even remotely foreseen what happened subsequently and the situation in...

Gary Varga (10/26/2016)

---

BWFC (10/26/2016)

---

ThomasRushton (10/26/2016)

---

Eric M Russell (10/25/2016)

---

Marcia J (10/25/2016)

---

I remember in the late 80's saying that the 2-digit year would be a problem and getting the message from other...

ThomasRushton (10/26/2016)

---

Eric M Russell (10/25/2016)

---

Marcia J (10/25/2016)

---

I remember in the late 80's saying that the 2-digit year would be a problem and getting the message from other programmers, "So what?...

Here's another way to do it

SELECT

PtLanguage

,Abington

,CAST(ROUND(CAST(Abington * 100 AS DECIMAL(9,3)) /SUM(Abington) OVER(),3) AS DECIMAL(6,3))AS Percent_Abington

,BelmontSt

,CAST(ROUND(CAST(BelmontSt * 100 AS DECIMAL(9,3)) /SUM(BelmontSt) OVER(),3) AS DECIMAL(6,3))AS Percent_BelmontSt

,Bridgewater

,CAST(ROUND(CAST(Bridgewater * 100 AS DECIMAL(9,3)) /SUM(Bridgewater)...

What do the numbers for each surgery represent? I'm assuming they are the counts of patients speaking each language.

Shell

You're welcome. Happy to help 🙂

Does this do what you need?

CREATE TABLE #example

(

first_nameVARCHAR(15)

,surnameVARCHAR(20)

,email_addressVARCHAR(60)

,countryVARCHAR(20)

)

INSERT INTO #example VALUES

('Andy','Capp','AndyCapp@thecouch.ie','Ireland')

,('Asterix','Thegaul','DesMenhirs@obelix.fr','France')

,('Hexe','Lilli','Spell@witches.de','Germany')

,('Paddington','Bear','Marmalade@sandwiches.pe','Peru')

,('blinky','bill','Up@bluegumtree.au','Australia')

SELECT

*

FROM #example e

ORDER BY

CASE WHEN country IN('Ireland'

,'France'

,'Germany')

THEN 1

ELSE 2

END

DROP TABLE

#example

jasona.work (10/18/2016)

---

BWFC (10/18/2016)

---

jasona.work (10/18/2016)

---

Brandie Tarvin (10/18/2016)

---

What a morning. SSC just broke my heart.

I see an article about time traveling listed in the newsletter. Get ready to read it and realize,...

Sean Lange (10/18/2016)

---

Grumpy DBA (10/18/2016)

---

Grant Fritchey (10/18/2016)

---

BLOB_EATER (10/18/2016)

---

Grant Fritchey (10/18/2016)

---

Wow, just read the comments on Reddit about a recent blog post... ouch.

Evidently stating the obvious when others are stating the...

jasona.work (10/18/2016)

---

Brandie Tarvin (10/18/2016)

---

What a morning. SSC just broke my heart.

I see an article about time traveling listed in the newsletter. Get ready to read it and realize, it's not...