Friday, 4 August 2017

SQL Server: dynamic columns based on row values (Date)

I have spent an hour already on this problem.



I want to dynamically generate columns based on the values from the column AttendanceDate.




I have found some similar questions, but unfortunately the examples were too complicated for me to comprehend.



Data:



enter image description here



Expected output:



enter image description here

-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

casting - Why wasn't Tobey Maguire in The Amazing Spider-Man? - Movies & TV

In the Spider-Man franchise, Tobey Maguire is an outstanding performer as a Spider-Man and also reprised his role in the sequels Spider-Man...