SQL Server PIVOT functionality

Question

If we PIVOT any table and UNPIVOT that table do we get our original table?

score 1 · Accepted Answer · answered Mar 04 '13 at 11:39

1

No, will not always get the same table as the original table. It depends on the kind of data that we are looking at.

Check the SQL Fiddles for @Mahmoud Gamal 's data.

SQL Fiddle With SUM

SQL Fiddle With MAX

answered Mar 04 '13 at 11:39

Ravi Singh

2,042
13
29

Please downvoter care to explain, what is the problem in this answer????????????? – Mahmoud Gamal Mar 04 '13 at 11:59

score 0 · Answer 2 · answered Mar 04 '13 at 11:00

0

No you can get different result. because use aggregate function in pivote. and when you unpivote pivoted query maybe get different result, that such as aggregated orginal table on pivote fields.

answered Mar 04 '13 at 11:00

mehdi lotfi

11,194
18
82
128

SQL Server PIVOT functionality

2 Answers2