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

345 reads

Blogs

Containers: Working With Volumes

By

In the previous two posts on containers I showed how use Docker commands to...

Speaking at PASS Summit 2019

By

I am delighted to announce that I have been selected to speak at the...

High Security Prices–Always Encrypted 2019 needs Datacenter Edition

By

I was recently doing some work on Always Encrypted in SQL Server 2019 and...

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

Query help on Pivoting on two columns

By s-sql

DECLARE @RegionCounts Table ( TYear char(2), Region varchar(30), RowCnt int ) Insert into @RegionCounts...

Response to Bloor article on SQL Provision

By gbritton1

I found the article https://www.sqlservercentral.com/articles/bloor-scores-sql-provision-4-5-out-of-5-for-test-data-provisioning Interesting if a little shallow.  It would be more...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers