Thursday, June 20, 2019

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)

plot explanation - Why did Peaches' mom hang on the tree? - Movies & TV

In the middle of the movie Ice Age: Continental Drift Peaches' mom asked Peaches to go to sleep. Then, she hung on the tree. This parti...