LISTING 8: Using the sp_CrossTab Stored Procedure

USE Northwind

EXEC sp_CrossTab
  @table       = 'Orders',
  @onrows      = 'MONTH(OrderDate)',
  @onrowsalias = 'OrderMonth',
  @oncols      = 'YEAR(OrderDate)'

USE Pubs

EXEC sp_CrossTab
  @table  = 'Sales',
  @onrows = 'stor_id',
  @oncols = 'YEAR(ord_date)',
  @sumcol = 'qty'