Last post Apr 11, 2016 09:33 AM by Weibo Zhang
Apr 09, 2016 09:46 AM|Allenteeno|LINK
Please how can I generate total attendance with percentage using either pivot or stored procedure using the below image?
Apr 11, 2016 09:33 AM|Weibo Zhang|LINK
Could you change a new available image to clarify your need? Then, you’d better provide your table structures and the expect final result.
As I’m not clear your table structures and the expected output, you could first have a look at below links to learn how to use the
Pivot and how to generate the percent value in SQL.
Pivot tables in SQL Server. A simple sample.
How to calculate percent on base?