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

354 reads

Blogs

Last Week Reading (2019-10-20)

By

Hello folks! 2 weeks passed but eventually, I have some news for you. Press...

GotoWebinar (and Teams) won’t screen share after macOS update to Catalina (10.15)

By

This blog post is about the situation where after upgrading to the latest macOS...

Read the latest Blogs

Forums

Update field in records w/ MIN timestamp

By ncraigg

I have a query that selects the record with the MIN timestamp based on...

Query Store - why is my query not in top resource consumers

By DamianC

Hello   I've been playing around with some of the out-of-the-box Query store reports...

STRING_SPLIT with Index as Table-Valued Function

By bteague

Comments posted to this topic are about the item STRING_SPLIT with Index as Table-Valued...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers