Probably this could help. The problem is that you have a char(10) and you're looking for 8-character strings.

SELECT *

FROM dbo.Postcode

WHERE p_code LIKE N'___ ___ ';

Brandie Tarvin (5/26/2016)

---

BWFC (5/26/2016)

---

Brandie Tarvin (5/25/2016)

---

Brandie Tarvin (5/25/2016)

---

Sigh. Wish wish wish...

Gazareth (5/25/2016)

---

jasona.work (5/25/2016)

---

Eirikur Eiriksson (5/25/2016)

---

Brandie Tarvin (5/25/2016)

---

Brandie Tarvin (5/25/2016)

---

Sigh. Wish wish...

Use a "self" join. In other words, join the table to itself.

Birthday

Bunny

I understand that you want that format. But the image you posted, has more data that the sample data you posted. I have no idea of what the numbers should...

That doesn't reflect the sample data you posted.

ziggy2016 (5/24/2016)

---

Many thanks to you and others who have contributed sofar. In the Month column, it displays avg but what I want is the percentages like 90% and so on....

This is what I use for "previous row" calculations on 2008. For 2012+, I would use LAG.

WITH CTE AS(

select *, ROW_NUMBER() OVER(PARTITION BY ID ORDER BY...

Here's an example.

The query is modified because I'm not sure that you're using the correct aggregates.

WITH CTE_Specialty AS(

SELECT Category ...

Brandie Tarvin (5/24/2016)

---

And now we shall call him the necroscripter.

EDIT: I wonder if he's grabbing all...

Gave an answer in this other thread: http://www.sqlservercentral.com/Forums/Topic1789162-3077-1.aspx

ziggy2016 (5/24/2016)

---

Hi Guys,

I hope someone can help me resolve the problem below:

FYTreatment FunctionAVG_ActivityAPRMayJUNJULAUGSEPTOCTNOVDECJANFEBMARYTD

2015/16Other150191949494949393929393919192

2015/16Ophthalmology63994969494959798989797959796

2015/16Trauma & Orthopaedics100390918989929492919391929191

2015/16Neurosurgery329295951001009494919596979094

2015/16Rheumatology11895949798969792919392979895

Over All Total329386%?86%?86%?86%?86%?86%?86%?86%?86%?86%?86%?86%?86%?

Basically, all I want is how get the bottom over all avg and percentages...

Remember that CONVERT won't reformat a string. The column needs to be a date/time data type to allow CONVERT apply the format code.