Please help me create the select sql in Microsoft SQL Server, i want convert from the table:
convert to the new table, get the distinct DeviceCode and new columns get from PartName values, and the PartName values is unlimit (DVD, Mouse, Keyboard, Monitor…..):
I just attach full image in there, with more sample data, sorry i cant add a table viewer in the post: https://farm6.staticflickr.com/5628/30615995995_a0ed8b65fa_o_d.jpg
I had a new solved detail quest in Topic:
Many thanks for the consultant Yared who help me solved this as my expected.
Best Regards, Hien Nguyen