Table of Contents

 

	Table of Contents
	Index
	Reviews
	Examples
	Reader Reviews
	Errata

Transact-SQL Cookbook
By Jonathan  Gennick, Ales  Spetic
Publisher	: O'Reilly
Pub Date	: March 2002
ISBN	: 1-56592-756-7
Pages	: 302
Slots	: 1			Copyright
		Dedication
		Preface
			Why We Wrote This Book
			Audience for This Book
			Which Platform and Version?
			Structure of This Book
			Conventions Used in This Book
			About the Code
			Comments and Questions
			Acknowledgments
		Chapter 1.   Pivot Tables
			Section 1.1.   Using a Pivot Table
		Chapter 2.   Sets
			Section 2.1.   Introduction
			Section 2.2.   The Students Example
			Section 2.3.   Implementing Set Difference
			Section 2.4.   Comparing Two Sets for Equality
			Section 2.5.   Implementing Partial Intersection
			Section 2.6.   Implementing Full Intersection
			Section 2.7.   Classifying Subsets
			Section 2.8.   Summarizing Classes of Sets
			Section 2.9.   Aggregating Aggregates
			Section 2.10.   Summarizing Aggregated Classes
			Section 2.11.   Including Nonaggregated Columns
			Section 2.12.   Finding the Top N Values in a Set
			Section 2.13.   Reporting the Size of a Set's Complement
			Section 2.14.   Finding the Complement of a Set
			Section 2.15.   Finding the Complement of a Missing Set
			Section 2.16.   Finding Complements of Sets with Different Universes
			Section 2.17.   Comparing a Set with Its Universe
			Section 2.18.   Dynamic Classification System
		Chapter 3.   Data Structures
			Section 3.1.   Types of Data Structures
			Section 3.2.   Working Example
			Section 3.3.   Finding Regions
			Section 3.4.   Reporting Region Boundaries
			Section 3.5.   Limiting Region Size
			Section 3.6.   Ranking Regions by Size
			Section 3.7.   Working with Sequences
			Section 3.8.   Working with Runs
			Section 3.9.   Cumulative Aggregates in Lists
			Section 3.10.   Implementing a Stack
			Section 3.11.   Implementing Queues
			Section 3.12.   Implementing Priority Queues
			Section 3.13.   Comparing Two Rows in an Array
			Section 3.14.   Printing Matrices and Arrays
			Section 3.15.   Transposing a Matrix
			Section 3.16.   Calculating a Matrix Trace
			Section 3.17.   Comparing Two Matrices for Size
			Section 3.18.   Adding and Subtracting Matrices
			Section 3.19.   Multiplying Matrices
		Chapter 4.   Hierarchies in SQL
			Section 4.1.   Types of Hierarchies
			Section 4.2.   Creating a Permission Hierarchy