Viewing 3 posts - 1 through 4 (of 4 total)
While I used PIVOT for years, there is little brother UNPIVOT that I never looked at! It's still not perfect while I have to list all the column name in...
April 16, 2010 at 6:48 am
Having the possibility to convert my Main table into a vertical structure like you suggest would be the best I agree but I can't right now. It is part of...
April 15, 2010 at 8:33 pm
The expected result would be:
NoIDPartNamePartSizePartValuePartTotal
1Area150507500
1NbRooms5100500
1NbGarage110001000
2Area170508500
2NbRooms4100400
2NbGarage010000
3Area180509000
3NbRooms6100600
3NbGarage210002000
April 15, 2010 at 6:28 pm
Viewing 3 posts - 1 through 4 (of 4 total)