Dynamic Pivot for Inconstant Number of Attributes in SQL Server

Selecting Patients with All Diseases Using PostgreSQL's Array Aggregation Functionality