In this case I would suggest to not using SQL server at all, just rely on scripting languages like Python, R and PowerShell.

You don't need to have the data in...

Thanks for your reply, I use the pivot quite often for management reporting so any insight is welcome.

Regards, JJ

My suggestion would be to use a PIVOT clause:

WITH cteSports AS (

SELECT * ,sn = ROW_NUMBER() OVER (PARTITION BY name ORDER BY sport)

FROM #example

)

SELECT name, city,...

Hi there,

There's also another method if you need not exacly 500 rows, but 500 rows or less per page.

You can use the following statement:

SELECT NTILE(1+(SELECT COUNT(*) FROM Tablename) / 500)...