Run Code  | API  | Code Wall  | Users  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

dynamic pivot

Language: Layout:
View schema
Execution time: 0,02 sec, rows selected: 13, rows affected: 9, absolute service time: 0,17 sec 
edit mode |  history  | discussion
   Id EmployeeId EquipmentId
1 1 1 1
2 2 1 2
3 3 2 1
4 4 2 3
   EmployeeId Equipment1id Equipment2id Equipment3id
1 1 1 2 NULL
2 2 1 NULL 3