Technical Article


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


379 reads


Removing a PowerShell Array Element–#SQLNewBlogger


I saw an article on this and realized I had no idea how to...

PostgreSQL Backup Failure


In this blog post I wrote a tip about fixing the PostgreSQL backup failure...

Dynamic Data Masking – SQL Server


Use Dynamic Data Masking to protect your data The post Dynamic Data Masking – SQL...

Read the latest Blogs


Need help with the query

By LearningDBA

How do I add 0 in the beginning but the length of the value...

GitHub Copilot - Our Best Ally for T-SQL

By Daniel Calbimonte

Comments posted to this topic are about the item GitHub Copilot - Our Best...

Lead Updates Not Working, Only Rendering Nulls

By Zososql

I hav a table that holds sports betting lines that i am using in...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers