I work on SQL Server 2014 I need to get data from compliance data table horizontally. based on part id and compliance type Id 1,2,11 every part id will have one row per 3 compliance type every row per part will have 3 compliance type id 1,2,11 if part not have 3 compliance then it […]