Transact-SQL Cookbook; Audience for This Book; Which Platform and Version?; Structure of This Book; Conventions Used in This Book; About the Code; Comments and Questions; Acknowledgments; From Jonathan; 1. Pivot Tables; 1.1.2. Solution; 1.1.3. Discussion; 2. Sets; 2.1.1.2. Elements; 2.1.1.3. Universes; 2.1.2. Set Operations; 2.1.2.2. Intersection; 2.1.2.3. Union; 2.1.2.4. Complement; 2.1.2.5. Difference; 2.2. The Students Example; 2.3. Implementing Set Difference; 2.3.2. Solution; 2.3.2.2. Subtracting one set from all others; 2.3.3. Discussion; 2.3.3.2. Subtracting one set from all others.;This cookbook contains a wealth of solutions to problems that SQL programmers face all the time. Recipes inside range from how to perform simple tasks, like importing external data, to ways of handling issues that are more complicated, like set algebra. Each recipe includes a discussion that explains the logic and concepts underlying the solution. The book covers audit logging, hierarchies, importing data, sets, statistics, temporal data, and data structures.