Click

Irfan.Baig (11/7/2016)

I think we can also remove duplicates using simplest, easiest and better way without using temp table/s logic:

WITH CTE_InsurancePolicy AS (

SELECT PolicyId, FirstName, Surname, PolicyStartDate, PolicyEndDate

,ROW_NUMBER() OVER...

Parrot

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)

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)

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)

Gary Varga (10/26/2016)

BWFC (10/26/2016)

ThomasRushton (10/26/2016)

Eric M Russell (10/25/2016)

Marcia J (10/25/2016)

ThomasRushton (10/26/2016)

Eric M Russell (10/25/2016)

Marcia J (10/25/2016)

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.