Apparently an orange turd with a straw comb-over has got a really important job somewhere. I can't quite understand it myself.

If they ever install that in our place, I'm doomed.

Yes this is possible, as demonstrated below. But, this is an extremely simplified example that may not be appropriate for your situation. If you post some sample data...

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