XTAB - CROSSTAB UTILITY

sp_XTAB (prototype) produces pivoted (crosstab) views/output with a minimum of fuss.No messing with code, just tell XTAB what you want to pivot.Tested to 764 pivoted columns, XTAB can generate up to 63000 characters of dynamic sql. Example (deliberately over-simplified)----------------------updated 27 January 2004Use NorthwindEXEC sp_XTAB 'Northwind','xtEMPL_COUNTRY','Orders','EmployeeID','ShipCountry', '', 'OrderID','COUNT','NULL', '', 'SELECT xtEMPL_COUNTRY.* FROM xtEMPL_COUNTRY' -- Include optional […]

2004-01-24

368 reads

Blogs

Daily Coping 13 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Last Week Reading (2020-07-12)

By

Press Azure resource providers operations List of all of the available ADF-specific RBAC permissions....

Daily Coping 10 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Disk space

By Admingod

I noticed the system volume information is consuming the disk space on database server...

Creating a Dimension with no Primary Key

By daithiboy

Hi all, I'm rebuilding some cubes in SQL Server 2017 using Visual Studio and...

Code signing a dll with certificate for use in SQL Server 2016

By fafful

I have a dll that will perform some webservice calls function. in order to...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers