New answers tagged

0

The hierarchical relationship in your crosstabbed columns (PropName/ValName) isn't really supported by the PIVOT command in SQL Server. An alternative approach is to write the normalized data out to CSV and then use a third-party tool that does support crosstabbing column groups like your PropName and ValName. One such tool is xtab.py (https://pypi.org/...


0

While I haven't done this exact sort of thing myself I would recommend installing Python and Pandas. This combination can: Directly query your database(s) Perform pivots with a little care on millions of data entries, see also Output to CSV or Excel formats Better yet it is all free, gratis & open source.


Top 50 recent answers are included