Friday 8 February 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)

php - file_get_contents shows unexpected output while reading a file

I want to output an inline jpg image as a base64 encoded string, however when I do this : $contents = file_get_contents($filename); print &q...