Pivot Table Aggregation - Converting Rows to Columns by Date

How to Generate Dynamic Pivot Table Columns with SQL Server's STRING_AGG Function and Parameterized Queries