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

A Quick Restore

While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:

USE DNRTest

BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak'
GO
/*
Bunch of stuff tested here
*/RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACE

What happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance.

See possible answers

XTAB - CROSSTAB UTILITY

Blogs

What is ALM in Fabric?

The Most Successful Startups in 2025 — And What They Have in Common

Blog a Day – Day 1: History of AI

Forums

A Quick Restore

Guarding Against SQL Injection at the Database Layer (SQL Server)

Ola Hallengren Index Optimize Maintenance can we have data compression = page

Question of the Day

A Quick Restore