DesNorton (3/3/2016)

---

The following code is a basic template that will get you what you are looking for.

DECLARE @SampleSize INT = 10;

SELECT *

FROM (

SELECT CUSTOMER_ID

...

pietlinden (3/2/2016)

---

Shot in the dark, since we don't have answers to Phil's questions, but here's a guess. I built this using AdventureWorks2012

SELECT [Name] AS TerritoryName

, t.TerritoryID

, tc.CustomerID

, tc.AccountNumber

FROM Sales.SalesTerritory...

Thanks, Hugo.

For the 10 records, I am not looking for these to be ordered, so no critieria would apply. I only need 10 records for the customer regardless of...

Hey Phil - the source data doesn't seem to be in any particular order, just random...although it might be on date but it is not arranged by customer.

Sean Lange (2/24/2016)

---

jakebeliveau (2/24/2016)

---

tindog (2/24/2016)

---

Are you after something like this:

SELECT NT_ID,

100 * Frequency / (SUM(Frequency) OVER ())...

tindog (2/24/2016)

---

Are you after something like this:

SELECT NT_ID,

100 * Frequency / (SUM(Frequency) OVER ()) PercentageOfTotal

FROM ........

ETA: prefix...

Hello tindog - I can't seem to upload any data so I could supply some examples...