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 […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-01-24

384 reads

Discuss

All authors

Blogs

Why Data Analysts Love PostgreSQL (and You Will Too!)

By Tracy McKibben

Data analysis is all about wrangling massive datasets. To do that efficiently, you need...

How to Connect Your WordPress Site to the Fediverse

By Rob Sewell

Make it easier for your audience to engage with you by connecting your site...

What I learned volunteering at a children's summer camp

By Rayis Imayev

"Stories are where memories go when they are forgotten" - Doctor Who.(2024-Sep-13) As September quickly...

Read the latest Blogs

Forums

GIT Configuration and Automated Release for Azure Data Factory

By Sucharita Das

Comments posted to this topic are about the item GIT Configuration and Automated Release...

How to Add a New Shared Disk to a WSFC as a SQL Resource

By muhkam

Comments posted to this topic are about the item How to Add a New...

AI Sings the Blues

By Steve Jones - SSC Editor

Comments posted to this topic are about the item AI Sings the Blues

Visit the forum

Question of the Day

Disabling Indexes

I want to disable an index so that it doesn't use any resources and isn't maintained. I am planning to drop this, but don't want to do it now. The index is named LoggerNCI and was created on the dbo.Logger table, on the LogID column. What code disables this?

See possible answers