From the Publisher
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.
From the Author
If you have recently learned SQL, then you know what the basic statements are all about. What you need to learn next is how to "think SQL" in order to creatively apply it to the programming problems you encounter in your daily work. This is a hard thing to "teach"; the creative application of SQL is really something you need to learn by example. That's the whole point of this book, to provide examples of SQL being used creatively, and in ways that aren't immediately obvious, to solve everyday problems. You'll be able to apply our patterns to your own work, and you'll no doubt be inspired to discover even more creative solutions of your own. This book isn't just for those who are new to SQL. Even if you're an experienced SQL programmer, you probably haven't seen it all, and we think you'll discover at least one new technique in this book.