Hi Experts, I have a situation as follows;
I have a table that stores the Year, Tournament, Category, Gender, Player and respective stat Count for tennis players. Using this information I want to present it in a better way using pivot and nested repeaters in ASP.NET. The tables are slam_detail (main data table) and category_detail (stores the names of the categories that players are assessed by)
A picture of the table is below. (I have also attached an Excel file with the data)
My desired output would be as follows;
If one query can do it - that would be awesome but I presume 2 queries will be needed then I can nest them to get the required output?
My issue is I'm out of ideas on what I would nest in what and how I would pivot the data.
I'm using SQL Server 2012