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

392 reads

Discuss

All authors

Read the latest Blogs

Visit the forum

Question of the Day

Adding and Dropping Columns II

I have this table in my SQL Server 2022 database:

CREATE TABLE [dbo].[CityList]
(
[CityNameID] [int] NOT NULL IDENTITY(1, 1),
[CityName] [varchar] (30) ,
[Country2] [char] (3),
[stateprovince2] [char] (2),
[Country] [char] (3),
[stateprovince] [char]
) ON [PRIMARY]
GO

I decide to drop the stateprovince2 and country2 columns. What code should I use?

See possible answers

XTAB - CROSSTAB UTILITY

Blogs

Deploying an Updated Model with SQL Compare 16

Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022

Looking Back at the Redgate 2026 Company Kickoff

Forums

Create filegroups in partition

Adding and Dropping Columns II

Leveraging DuckDB for OLAP Workloads: The Fabric Modern Data Platform

Question of the Day

Adding and Dropping Columns II